View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jonsson Jonsson is offline
external usenet poster
 
Posts: 45
Default Macro that asks for password

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