Login.

[Nigel Martin]

I have a worksheet with a photo on it with a macro attached that unhides a worksheet with that particular persons details on it. What code would I need to add to the macro that unhides the worksheet but before that would prompt the user for a login/password otherwise if they do not know the login/password leave the user on the worksheet with the photo on it?

 

[Al Chara]

How about something simple, like the following code:

password = InputBox("Enter Password")
If password = "YourPassword" Then Worksheets("Sheet1").Visible = True

Substitute your password for YourPassword and your sheet for Sheet1.

 

[Nigel Martin]

Many thanks Al it works well.