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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
password for macro 3
Need Help with a VBA subroutine 0
Slight VBA hickup 3
Open to modify 3
Table Security in Access 2013 1
Novice - using macro to protect with password 10
Customized WorkSheet Password 0

Top