password a worksheet

  • Thread starter Thread starter Moh
  • Start date Start date
M

Moh

i have a worksheet in a workbook i need a password so no one can view it.
only the main user can view it by entering the password
it contain valuble information about the company

can someone help to create a password box from the main menu to open the
worksheet.

if the password id incorrect then it should take the user back to the main
menu.

Please help
 
Moh said:
i have a worksheet in a workbook i need a password so no one can view it.
only the main user can view it by entering the password
it contain valuble information about the company

can someone help to create a password box from the main menu to open the
worksheet.
Click to expand...

You can password-protect a workbook but not an individual workSHEET within
that workbook AFAIK....
 
Gordon ok say if i create a userform called userform4

i have a label1 "password"

textbox1 for the user to type the password in

Commandbutton1 is OK - if password is correct then take me to Banking Sheet
- if wrong password the Sorry please re-enter the correct password.

Commandbutton2 is Cancel - this should return to main menu

now how will all this work?
 
Although its possible to create something like that, it would not be secure,
as you would just be making a code to unhide a worksheet, which Excel does
not have a built in feature to password protect. I'd think the best you can
do is have your banking sheet in a seperate workbook, and password protect
that. You could do a hyperlink then from your first workbook to the "Banking
Sheet" (which is in a different, seperate workbook)

I'm also not sure how secure you are trying to get. I've heard Excel
passwords are not the strongest.
 
luke or anyone can you tell me how to use the userform4 with the password

i create a userform called userform4

i have a label1 "password"

textbox1 for the user to type the password in

Commandbutton1 is OK - if password is correct then take me to Banking Sheet
- if wrong password the Sorry please re-enter the correct password.

Commandbutton2 is Cancel - this should return to main menu


the end user isn't much of a wizkid to understand how to switch to the other
sheet.

Thank you
 
Back
Top