How can I get excel to show in a particular cell whether the active worksheet is protected or not, (not whether a cell is locked or not)
Many thanks for any help
How can I get excel to show in a particular cell whether the active worksheet is protected or not, (not whether a cell is locked or not)
Many thanks for any help
Good afternoon Dances With Car
...and welcome to the forum!!
You will need a UDF (User Defined Function) for this one. Stick this into a normal module :
Then use this formula in your cell :Please Login or Register to view this content.
=Protection()
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Hi Domonic
Thankyou for the welcome, the very fast reply and of course the code which I've successfully inserted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks