Microsoft Office Tutorials and References
In Depth Information
Unlocking nonformula cells
2. In the Protect Sheet dialog box, specify a password (if desired). If you don’t specify a
password, anyone can unprotect the sheet and see (or modify) the formulas.
3. Click OK, and you will be prompted to reenter the password.
When you protect a worksheet, many common actions are disabled. For example, the user cannot
insert rows or columns, change column width, or create embedded charts. Use the options in the
Protect Sheet dialog box to specify the actions that are allowed when the sheet is protected.
After performing these steps, cells that contain a formula are not displayed in the Formula bar. If the
user attempts to edit the cell, the alert box shown in Figure 49-3 appears. Nonformula cells can be
edited, as usual.
Figure 49-3: This alert box appears if the user attempts to edit a formula cell.
Keep in mind that it is very easy to break the password for a protected sheet. If you’re
looking for absolute security, hiding and locking formula cells is not the solution.