Create Password

[Guest]

I wish to make a particular worksheet available in a workbook only to certain
users who know a password to access it. Is there a way to create a password
dialog box (i.e., InputBox) that prompts a user but displays only asterisks
when they type the password? Thanks.

 

[Guest]

You can use a UserForm with a text box and a button. Set the PasswordChar
property of the textbox to "*".

 

[JE McGimpsey]

You'd need to use a textbox in a UserForm (set the PasswordChar property
to *).

However, be aware that it takes only the minimal ability to find these
groups in order to bypass any protection.

If you want actual security, don't send workbooks to people who
shouldn't see all the sheets.

 

[Guest]

Thanks, Vergel. That's what I needed!