Microsoft Excel provides several layers for protecting your sheet and workbook. For example, you can protect your entire workbook, or you can protect a sheet and other elements in your sheet. Or you can protect your workbook structure from deliberate deleting or un-hiding your sheets by other users.
To prevent your workbook structure, you have two different options of doing this.
1) You can visit REVIEW ribbon and click "Protect Workbook". This will open up a dialog box "Protect Structure and Windows". Select the "Structure" Checkbox and provide a password to lock your workbook structure. The password in this is optional but it is advisable to use a password to protect the structure.
2) You can visit FILE option and select the "Protect Workbook" option. This will further open up the same dialog box "Protect Structure and Windows". And rest you can follow the same instruction given above.
Protecting your workbook structure will not allow other users to deliberately delete, add or change the sheet in the workbook. Infact this will disable the "Right Click" features available to delete, add and move or copy, hide and unhide features.
For more details on the sheet and workbook protection features please get in touch with me at Samrat.biswaas@gmail.com
Samrat Biswas, MOS Excel 2013, ITIL V3 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), MS Visio, MS Project, and MS SharePoint.
--------------------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
No comments:
Post a Comment