Access Hidden Worksheet With A Password

[Chris Wareham]

Hi Folks, i have a workbook with 2 sheets 1st named Form 2nd named Database, i have hidden from view worksheet 2 ( Database ).
Sheet 1 ( Form ) is a user form that sends data to sheet 2 ( Database ).
Is there a way that i can create a command button in the Userform that allows only users to access sheet 2 ( Database ) with a password and then closes back to being hidden again.

Regards Chris

[Hyflex]

If this is possible there is a problem with the user will be able to find the password by just editing macros

[Chris Wareham]

thats fine i dont think that they have the skills to be able to edit macros, regards chris

[Paul]

You could probably put two command buttons on the sheet/form and use the following code (adjust as needed):

Please Login or Register  to view this content.

Then, so users cannot simply open the VB Editor and see your code (and password), in the VB Editor (ALT+F11) go to Tools - VBAProject Properties - Protection tab and select 'Lock project for viewing' and set a password.

Don't forget this password!

[Chris Wareham]

Already sussed that part many thanks