If you lock the Workbook’s structure, your co-workers can still contribute data to individual Worksheets – they just can’t alter how the Workbook has been set up and organized. Doing this prevents other people from viewing hidden Worksheets, as well as adding, moving, deleting, hiding, or renaming Worksheets they’re not working on, or shouldn’t have permission to change.įor example, let’s say you created a Workbook for a complex team project. Use a password to control who can change the structure of your WorkbookĪnother way to protect your spreadsheets is by locking down the structure of your Workbook. Now, anyone with access to the file must enter a password to access the Workbook as read-only, and another to gain full editing access. Enter a password in the ‘Password to modify’ field.If you’re using a Mac, follow these steps: Enter a password for editing access, then select OK.Select the Protect Workbook box and choose Always Open Read-Only.Securing your spreadsheets this way lets you give people different and appropriate levels of access. For example, if you’re using Excel at work, you might want to give full editing permissions to your manager and read-only access to everyone else.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |