Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a PASSWORD ENTRY BOX at startup of Excel Application
I have an application that I would like to add a password entry box.
The box would appear on the screen when a workbook is opened and the user would have to enter a password to be able to use the workbook. The password entry box would contain two buttons: SUBMIT - Submits the password CANCEL - This would close the workbook without saving. The password would be written into the workbook (most likely in the first spreadsheet) and the user would have to enter the password that matches. If the password is incorrect then the workbook would display a message box with a message like, "Sorry, but you have entered an incorrect password. Please re-enter the correct password." The user would be able to close this message box and try re-entering the workbook. I would be most grateful if you could let me know what VBA code I would need to write to accomplish the above. Please respond via email: Thank you so much. Marcello |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a PASSWORD ENTRY BOX at startup of Excel Application
Hi Marcello,
Why not just save the workbook as a password-protected workbook. The steps to do this depend on your Excel and operating system versions, but for Excel 2000+ and Windows 2000+ choose File/Save As from the Excel menu. In the Save As dialog select the Tools/General Options menu. In the Save Options dialog enter a Password to open. Don't enter or select any of the other options. Excel will prompt you to verify the password and then in will be saved password-protected. Once you've done this, the user will not be able to open the workbook without knowing the password. And unlike all other password protection options available in Excel, this one has the advantage of being truly difficult to break. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Marcello do Guzman" wrote in message ... I have an application that I would like to add a password entry box. The box would appear on the screen when a workbook is opened and the user would have to enter a password to be able to use the workbook. The password entry box would contain two buttons: SUBMIT - Submits the password CANCEL - This would close the workbook without saving. The password would be written into the workbook (most likely in the first spreadsheet) and the user would have to enter the password that matches. If the password is incorrect then the workbook would display a message box with a message like, "Sorry, but you have entered an incorrect password. Please re-enter the correct password." The user would be able to close this message box and try re-entering the workbook. I would be most grateful if you could let me know what VBA code I would need to write to accomplish the above. Please respond via email: Thank you so much. Marcello |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I protect all excel tabs in a file with one password entry? | Excel Discussion (Misc queries) | |||
Excel or Access for Data Entry and Reporting Application | Excel Discussion (Misc queries) | |||
create excel based standalone application | Excel Discussion (Misc queries) | |||
create installer for Excel application | Excel Discussion (Misc queries) | |||
How to password protect an application | Excel Programming |