Userform to enter password to unhide very hidden sheet

Hi,

I have a sheet in a workbook (named 'Leader') which is veryhidden.

I have a user form (named 'frm1') where the password (for testing purposes the password is 'MyPassword') can be entered but it shows in the box as asterixs'

I've been reviewing previous posts and searching the net for suggestions of how to write the vba for such an event but I've come up empty handed and I'm getting more and more confused.

I'd be very appreciative of anyone who can suggest a code that would allow me to set the userform so that it unhides the worksheet 'Leader', and also gives a message box if the wrong password is entered.

Sorry for the lack of code and thanks in advance for any help provided.

Regards.

so are you looking for the VBA to unhide a very hidden sheet? if so this (change it to your requirements) but I don't know if a userform has any effect on it.

HTML Code: 

You’re welcome AND thanks for the rep!

Originally Posted by dori2o

I've managed to work it out with the following code.

How secure does this have to be?

Is your VBA project also password-protected? If not, a user can simply read the code to see the password. Even easier, a user can go to the VBA development window and make the sheet visible.

In general, Excel security features are only effective against compliant users. A compliant user is someone who sees a prompt for a password and will say, "Oh, I don't know the password so I am not authorized to see this." A malicious user who says, "I want to see this even if I'm not authorized" will always find a way, and it's not that hard.