Protect Your Work
Anyway, in addition to protecting the cells in the sheet which I have covered in other blogs, today I want to talk about protecting your workbook's structure. It is easy to do and you will wish that you knew about this a long time ago.
These steps pertain to the entire workbook - not just a worksheet.
- Click Review.
- Select Protect Workbook which is located in the Changes grou.p
- Select Structure Option in the Protect Workbook dialog box.
- 4. Click OK.
If you select Windows, you can prevent users from changing the size or position of worksheet windows.
This tip is very useful if you are linking together several spreadsheets maintained by others.