How do I easily password protect a worksheet and allow user to modify password?
Posted on 2011-04-19
I'm looking for a way to password protect several sheets in a workbook. I've gotten a document that does exactly what I want, but I coded the passwords in the vba. Now, I'm asked to make it easy for an admin to modify the various passwords.
I've found tons of stuff that after supplying a password, certain sheets are visible. But, what I'm having trouble with is how to allow the document to 'reprotect' a sheet based off a password on a stored sheet.
This way, if the Admin opens the document with nothing protected, then makes changes to the passwords for various sheets, the document re-protects the sheets using the new passwords.