Home

Show is sheet is protected or not.

%3CLINGO-SUB%20id%3D%22lingo-sub-740873%22%20slang%3D%22en-US%22%3EShow%20is%20sheet%20is%20protected%20or%20not.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740873%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20have%201%20cell%20in%20a%20worksheet%20change%20from%20green%20to%20red%20is%20sheet%20is%20protected%20or%20not.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20this%20be%20done%20with%20conditional%20formatting%20or%20a%20macro%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-740873%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERequests%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-740882%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20is%20sheet%20is%20protected%20or%20not.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740882%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372032%22%20target%3D%22_blank%22%3E%40Roger214%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcelribbon.tips.net%2FT009639_Visually_Showing_a_Protection_Status.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcelribbon.tips.net%2FT009639_Visually_Showing_a_Protection_Status.html%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-742532%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20is%20sheet%20is%20protected%20or%20not.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-742532%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20that%20information.%20I%20believe%20I%20found%20that%20in%20a%20search.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20didn't%20have%20much%20luck%20with%20that%2C%20probably%20because%20I%20don't%20know%20how%20to%20create%20a%20user%20defined%20'function'.%3C%2FP%3E%3CP%3EIf%20you%20have%20any%20tips%20on%20that%2C%20I%20would%20grateful.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERoger%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743377%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20is%20sheet%20is%20protected%20or%20not.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743377%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372032%22%20target%3D%22_blank%22%3E%40Roger214%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERoger%2C%3C%2FP%3E%0A%3CP%3ERight%20click%20on%20any%20sheet%20tab%20and%20click%20on%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20203px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122614i4876B7BAFFF3E12F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EHere%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20243px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122615iAF9AEF910908B3A6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ecopy%2Fpaste%20both%20functions%20in%20appeared%20window%20and%20save%20your%20workbook%20as%20macro-enabled%20(.xlsm)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Roger214
New Contributor

I am trying to have 1 cell in a worksheet change from green to red is sheet is protected or not.

 

Can this be done with conditional formatting or a macro?

3 Replies

@Sergei Baklan 

 

Thank you for that information. I believe I found that in a search.

 

I didn't have much luck with that, probably because I don't know how to create a user defined 'function'.

If you have any tips on that, I would grateful.

 

Roger

Highlighted

@Roger214 

Roger,

Right click on any sheet tab and click on

image.png

Here

image.png

copy/paste both functions in appeared window and save your workbook as macro-enabled (.xlsm)

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
207 Replies