VBA to unlock password protected sheet using cmd button
Hello happy campers!!
I have
Excel sheet, with 2 command buttons "Lock" & "Unlock"
Press cmd button1, this will password protect the sheet with password as "secret" (have this set up already)
Press cmd button 2, this will then produce a text box to require a user to put the specific password in to enable them to modify the sheet, otherwise it will stay locked.
Any advice would be very much appreciated!
galvinpaddy
Last edited by galvinpaddy; 11-22-2011 at 11:16 AM. Reason: updated
You have not specified the issue you are facing.
i do apologise!
Basically i would like the code that will make cmd button2 work.
I require the button to open a text box, requesting the password, then if the password entered is correct then it will unlock the sheet for editing.
I have a cmd button to lock the sheet with a set password, its just the text box & unlocking i am fighting with.
Thank you very much
galvinpaddy
Might be worth mentioning, the code i have for locking is simply:
Not sure on how to modify this to request a password when the user clicks on cmd2 button (unlock)
Please Login or Register to view this content.
This is the code you need -
Please Login or Register to view this content.
Great, thanks fella.
Works a treat and quick response also!! nice one 10/10
Mucho Gracias
My pleasure....thanks for the rep....
please mark as solved
Thankyou
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks