Use macro button to unhide veryhidden sheets and password protect it

[CV899000]

Hi,

I have several sheets that are I have set to become veryhidden when closing my workbook.

I have a macrobutton that I can press, and it will unhide the sheets.

Can I somehow create a password that I have to enter when pressing the macro to unhide the sheets?

 

[GTO]

Yes.

Do you need the password obfuscated while being typed?

 

[CV899000]

If possible then yes.
But if it is to much of a trouble, then I could live without it.

 

[GTO]

Thank you. Sorry, I should have asked you to post the code you have that is unhiding stuff. Please use code tags for posting code, like: [code=rich]'...your code between the tags[/code]

Have you used/created userforms before?

Mark

 

[CV899000]

Hello,

Yes, sorry about that.

Yes, I have done it once before. So I now how to do it, but I just need help with the code part.

 

[CV899000]

If I have to create a userform, can I then also have the user input a username e.g. the users e-mail address and a password?

E.g. I have one user that need to use several sheets by unhiding them with the macrobutton, we can call him a kind of superuser.

Then I have myself, as a kind of admin that needs to be able to access all sheets with the macrobutton,

then I have all other users that should not be able to "login" to unhide the sheets.

 

[CV899000]

Can anybody help with this matter?