Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password/Multiple Sheets
I would like a macro that when pushed it will display a
message "please insert password" if the password entered is correct then it will goto sheet2 if the password is incorrect it will display a message "Incorrect Password" and go to sheet1 thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password/Multiple Sheets
Glenn,
Copy/Paste this code into a regular module: Sub Pwd() Dim passwd As String passwd = InputBox("Please enter password: ", "Password Input") If passwd = "xyz" Then Sheets(2).Visible = True Sheets(2).Activate Else MsgBox "Wrong Password" Sheets(1).Activate End If End Sub And then create a button from the "Forms" toolbar and when prompted, assign it to this macro. John "Glenn" wrote in message ... I would like a macro that when pushed it will display a message "please insert password" if the password entered is correct then it will goto sheet2 if the password is incorrect it will display a message "Incorrect Password" and go to sheet1 thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro password-All sheets visible | Excel Discussion (Misc queries) | |||
Password Protected Sheets | Excel Discussion (Misc queries) | |||
Password Access to certain sheets | Excel Worksheet Functions | |||
password protect sheets | Excel Worksheet Functions | |||
Protecting Multiple sheets with prompt for password to unprotect | Excel Programming |