Hi There,
I am working on multiple sheets. I need VBA code to protect the all the sheets by one macro and to un-protect VBA should ask the correct password. Please note that the spreadsheet should have read-only access.
Please help!!
Thanks
Hi There,
I am working on multiple sheets. I need VBA code to protect the all the sheets by one macro and to un-protect VBA should ask the correct password. Please note that the spreadsheet should have read-only access.
Please help!!
Thanks
Last edited by Max_excel; 08-21-2013 at 05:47 AM.
Essentially:
but you will probably need to tweak/add error handling to suit your needs.Please Login or Register to view this content.
Hi yudlugar,
Appreciate your help.
I have a master password to protect all the sheets e.g test. My requirement is when I run the macro to Protect, the macro should protect the spreadsheets using master password and without a password prompt. And when i run macro to unprotect, it should prompt for correct password i.e test. In your code, any user can protect and un-protect the sheets with their own password.
Sorry I may not have been clear in my initial post.
Please Login or Register to view this content.
Many thanks for your help.
Last one, I need a msgbox to alert if an incorrect password is entered when macro Un-protect is run.
Regards,
Please Login or Register to view this content.
Many Many Thanks Yudlugar..
Can you help me mask the password in this VBA code as well please?
Last edited by Max_excel; 08-22-2013 at 10:55 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks