I have an application that I would like to add a password input 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

This question was answered yesterday. Simply save the
workbook password protected.

Replies to NewsGroup not direct - this is a forum for
sharing information

-----Original Message-----
I have an application that I would like to add a
password input 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
.

What's wrong with the buiklt in functionality? When saving click on
Tools or Options and you can enter a password to open or password to
modify.


---
~~ Message posted from http://www.ExcelForum.com/