Anyone know of a way to protect hidden worksheets, so that users cannot view the sheets without a password? Thanks.
Anyone know of a way to protect hidden worksheets, so that users cannot view the sheets without a password? Thanks.
Sure, when hiding a worksheet via code use the term like thisthis sheet cannot be unhiden by a normal user it can only be unhidden via code, so all you need is a small userform with a textbox to enter a password and then make the sheet visible like this:Please Login or Register to view this content.
Please Login or Register to view this content.
Not all forums are the same - seek and you shall find
Thanks a lot, I'll give it a try.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks