Alert if Sheet is Unprotected

[loomroser]

I sometimes unprotect a sheet to change a formula and then forget to reprotect it.

I would like "UNPROTECTED" to show in a cell so I am alerted to the fact that the worksheet needs to be protected.

I'd very much appreciate some help in how to achieve.

[royUK]

Something like this would trigger a message when the sheet calculates

Please Login or Register  to view this content.

[loomroser]

Thanks for you suggestion Roy. I came across the above event handler which should do what you are suggesting but by moving to a different cell instead of when the sheet recalculates but I don't know how to get the statement to work.

Your help would be much apprecited

[royUK]

Do you mean

Please Login or Register  to view this content.