Hi,
I have few sheets in my workbook however at a time only 1 is visible and on clicking on a command button with sheet name that sheet open and remaining get hidden.
Macro as below:
Sub Button1_Click()
ActiveSheet.Unprotect Password:="1234"
Sheets("Sheet2").Visible = True
Sheets("Sheet1").Visible = False
ActiveSheet.Protect Password:="3456"
End Sub
Instead of having the password in the macro itself I wish the macro to ask user for the password so that it can be open by intended user only.
Please note the un-protect password and protect are not same for reason that user can modify the sheet.
As I have said there are different sheet in the workbook each will have separate password so that only intended person can open the intended sheet.
Just to clarify before closing the sheet a macro will run and change the password of each sheet to the one with user so that next when he click on the sheet button he can open it using his password.
My question is still the same and i believe simple just beyond my knowledge: how to make Macro ask for user password.
Hope for the earliest reply, thanks in advance.
Reg,
Vishu
Bookmarks