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?
Please check this https://excelribbon.tips.net/T009639_Visually_Showing_a_Protection_Status.html
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.
Right click on any sheet tab and click on
copy/paste both functions in appeared window and save your workbook as macro-enabled (.xlsm)