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 |
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.... |
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.... |
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.... |
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.... |
All times are GMT +1. The time now is 04:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com