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

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

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

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

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