Jul 06 2019 08:29 AM
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?
Jul 06 2019 08:44 AM
Jul 08 2019 06:52 AM
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
Jul 08 2019 11:35 AM
Roger,
Right click on any sheet tab and click on
Here
copy/paste both functions in appeared window and save your workbook as macro-enabled (.xlsm)