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.
--
Steve C

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


--
Hope that helps.

Vergel Adriano


"Steve C" wrote:

> 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.
> --
> Steve C

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.

In article <8819FEEC-DA23-4C5F-A298-(E-Mail Removed)>,
Steve C <(E-Mail Removed)> wrote:

> 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.

Thanks, Vergel. That's what I needed!
--
Steve C


"Vergel Adriano" wrote:

> You can use a UserForm with a text box and a button. Set the PasswordChar
> property of the textbox to "*".
>
>
> --
> Hope that helps.
>
> Vergel Adriano
>
>
> "Steve C" wrote:
>
> > 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.
> > --
> > Steve C