Prevent Unauthorized Opening of Workbook

To enter a password:

1. From the File menu, select Save as.
2. From the Tools dropdown list, select General Options (in Excel 97 select Options).
3. In the Save Options dialog box, enter passwords into Password to open and Password to modify boxes, and click OK.

Excel 2002 and Excel 2003 offer additional options:
1. From the Tools menu, select Options, and then select the Security tab.
2. Enter passwords in Password to open and Password to modify boxes and click OK.

Screenshot // Prevent Unauthorized Opening of Workbook
Prevent Unauthorized Opening of WorkbookPrevent Unauthorized Opening of Workbook

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.