Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
password a worksheet
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 -- please can you help... its urgent |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
password a worksheet
"Moh" wrote in message
... 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. You can password-protect a workbook but not an individual workSHEET within that workbook AFAIK.... |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
password a worksheet
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? -- please can you help... its urgent "Gordon" wrote: "Moh" wrote in message ... 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. You can password-protect a workbook but not an individual workSHEET within that workbook AFAIK.... |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
password a worksheet
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. -- Best Regards, Luke M "Moh" wrote: 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? -- please can you help... its urgent "Gordon" wrote: "Moh" wrote in message ... 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. You can password-protect a workbook but not an individual workSHEET within that workbook AFAIK.... |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
password a worksheet
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 -- please can you help... its urgent "Luke M" wrote: 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. -- Best Regards, Luke M "Moh" wrote: 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? -- please can you help... its urgent "Gordon" wrote: "Moh" wrote in message ... 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. You can password-protect a workbook but not an individual workSHEET within that workbook AFAIK.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i unprotect worksheet with no password? | Excel Discussion (Misc queries) | |||
Worksheet password | Excel Discussion (Misc queries) | |||
I need to unprotect a worksheet but I don't have the password. | Excel Discussion (Misc queries) | |||
Protect a worksheet with a password | Excel Worksheet Functions | |||
Can you password an Excel worksheet, if so how? | Excel Worksheet Functions |