It's also possible to protect macros in the workbook from being removed or changed.įollow the steps below for your version of Excel to protect a worksheet or individual cells in a worksheet. Next, click Passwords near the bottom of the drop-down menu. Data in the protected cells, worksheet, or workbook cannot be added, changed, or removed. Open the workbook and then click File in the desktop’s menu bar. Protection can be configured in an Excel spreadsheet for individual cells, a single worksheet, or an entire workbook to prevent modification. Removing a password - To remove the password from a protected document, follow the steps in the previous section, but delete the characters entered in the Password field. Keep in mind, however, that a user could open the file then copy its contents another document. There will be a different password for each worksheet, with a possible 100 sheets in the workbook. Password to modify - Similar to read-only, this option allows the file to be viewed, but only users with the password may edit and save the file. Password to open - Entering a password for this option makes the file only readable by users who know the password.
0 Comments
Leave a Reply. |