Show is sheet is protected or not.

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
Highlighted
Highlighted

@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)