| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password prompt when sheet is activated
Is there a way to be prompted for a password when the worksheet is selected,
therefore they are unable to see the sheet until the password is correct TIA Michael |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Password prompt when sheet is activated
On the menu bar: ToolsProtection then enter your password to protect the
sheet. Be sure it is a password you can remember. "mmc308" wrote: Is there a way to be prompted for a password when the worksheet is selected, therefore they are unable to see the sheet until the password is correct TIA Michael |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Password prompt when sheet is activated
Sorry, you wanted to prevent the user from seeing the sheet. You would have
to hide the sheet and protect it. "mmc308" wrote: Is there a way to be prompted for a password when the worksheet is selected, therefore they are unable to see the sheet until the password is correct TIA Michael |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Password prompt when sheet is activated
JLGwhiz
Thanks for your reply If I hide the worksheet how are the users going to know quickly which tab to select to get the data without going through the process of unhiding the sheet in the format menu? Michael "JLGWhiz" wrote: Sorry, you wanted to prevent the user from seeing the sheet. You would have to hide the sheet and protect it. "mmc308" wrote: Is there a way to be prompted for a password when the worksheet is selected, therefore they are unable to see the sheet until the password is correct TIA Michael |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Password prompt when sheet is activated
If you do not want the user to see the sheet until they provide a valid
password, you have no choice but provide some means (menu or userform) from which they can select the desired sheet. Then you show a password entry form, if successful, unhide the worksheet, otherwise say "Unsuccessful". NickHK "mmc308" wrote in message ... JLGwhiz Thanks for your reply If I hide the worksheet how are the users going to know quickly which tab to select to get the data without going through the process of unhiding the sheet in the format menu? Michael "JLGWhiz" wrote: Sorry, you wanted to prevent the user from seeing the sheet. You would have to hide the sheet and protect it. "mmc308" wrote: Is there a way to be prompted for a password when the worksheet is selected, therefore they are unable to see the sheet until the password is correct TIA Michael |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| userform open when sheet activated | Excel Programming | |||
| Load VBA on Activated Sheet | Excel Programming | |||
| Unprotecting sheet did not prompt for password | Excel Programming | |||
| Error sheet when macro's are not activated | Excel Programming | |||
| password prompt to unhide sheet | Excel Programming | |||
Hybrid Mode
