Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Password
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Password
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Password
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Password
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 , 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get create one password for multiple tabs/worksheets? | Excel Discussion (Misc queries) | |||
Create Secure Data (need employee ID & password to access) | Excel Discussion (Misc queries) | |||
how to create password for an folder | New Users to Excel | |||
How do I create a required password before opening an excel doc? | New Users to Excel | |||
How do I create a password to unprotect cells in Excel | Excel Worksheet Functions |