Login.

Nigel Martin · Mar 20th, 2002, 06:40 AM

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 · Mar 20th, 2002, 08:38 AM

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 · Mar 20th, 2002, 01:57 PM

Many thanks Al it works well.

Mar 20th, 2002, 08:38 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	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. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 06:40 AM	#1
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	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?

Mar 20th, 2002, 01:57 PM	#3
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	Many thanks Al it works well.