Macro that asks for password

J

Jonsson

Hi,
I have sheet1 who which I want to protect with a password.
I want to create a macro and a button in sheet2, that asks for a password
when I want to run the macro to get access to sheet1.
The first time I run it I want a dialogbox that gives me opportunity to
choose password.
After that I want the macro to ask for the password, before open the sheet.

Is it tricky?

Regards, Thomas
 
Top