I am using following macro to hide and show sheets for specific password. I'm wondering if I can get a "public" password that would unhide ALL sheets but in "read only mode" or "protected workbook", meaning if someone again signs in with user password, he'll be able to input data normaly.
Please Login or Register to view this content.
with:
Thank you for suggestions!Please Login or Register to view this content.
Maybe I'm misunderstanding. You want the user to input a password, have all sheets unhide in read only or protected mode and still allow the user to input data manually? If that's the case, then I don't think it would be possible for them to enter anything into the sheet as read only/protected mode wont allow it to happen.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
No, let's say each time you open the document you have a chance to view it in different options. One of the options should be unhide all sheets in "protected sheet view", after you close the document (with a second code mentioned above) it hides sheets again and by entering a password next time opening the document you view it as defined in macro options.
This will unhide all sheets in protected mode...
Assign it to a button for the user to run it, or, put it in a Workbook_Open event to have it run when the workbook opens.Please Login or Register to view this content.
Thank you!
How can I add an option when workbook is closed it should "un-protect" all sheets to enable user to input data next time the workbook is opened?
Put this in ThisWorkbook
Please Login or Register to view this content.
Not sure I understood.
First macro does not ask me for password, second option has no effect on workbook.
ok, for the first code try..
This will ask for a password and unhide all hidden sheets in protected mode. The password is password as in the code.Please Login or Register to view this content.
The 2nd code unprotects all the sheets when the workbook opens. You can assign that to a button instead
I appreciate the amended code.
I would need a code when workbook is being closed it disables "protected view" and returns document in same format as before activating the macro.
Any ideas?
Thank you!
This will do it, place it in the ThisWorkbook section
Please Login or Register to view this content.
For this:
You could write:Please Login or Register to view this content.
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Oh, and just because a worksheet is protected and hidden doesn't mean you can't unhide it
Thanks for the info Trevor, but I'm afraid I'm not familiar withAs for the hidden part, very true, if they know there are hidden sheets, they can unhide them easily with a click or 2.Const myPassword As String = "1111"
Const is a constant, same as a variable but, well, constant, not changing. So, for something like a password, you can use a constant rather than defining a variable and setting its value somewhere else in the code.
As for the hidden sheet(s), just making the point that just because it is hidden, even very hidden, it's not safe or secure.
Regards, TMS
For reference: https://msdn.microsoft.com/en-us/lib...(v=vs.60).aspx
TMS,
I've tried using Const for the password, and I like it, it's a bit cleaner looking in the code than the Dim etc. Thanks again.
@gmr4evr1: You're welcome. Thanks for the rep.
No problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks