Enter a password in the p assword to modify box, then click OK.
Some of the steps are the same as the file open password, but they are repeated here for completeness. The file modify password prevents the workbook from being changed until a password has been entered. As these passwords cannot be easily recovered. (Remember that passwords are case-sensitive.) It is advisable to keep a list of passwords and their corresponding workbook and sheet names in a safe place. Warning Messageĭid you notice the warning message which appeared when setting the password?Ĭaution: If you lose or forget the password, it cannot be recovered. A user cannot open the workbook until the password has been entered. Finally, enter a file name and click Save in the Save As window.In the Confirm Password window, re-enter the password and click OK.
Enter a password in the password to open box, then click OK. The file open password prevents an Excel workbook from opening until the password is entered. There are five different passwords within Excel:Įach of them is applied differently and serves different purposes.
