Protect workbook elements

1. On the Review tab, in the Changes group, click Project Workbook.
2. Under Project workbook for, do any of following:
· To protect the structure of a workbook, select the Structure check box.
· To keep workbook windows in the same size and position each time the workbook is opened, select the Windows check box.
Select this check box To prevent users from
Structure
Recording new macros.

1. Viewing worksheets that you have hidden.
2. Moving, deleting, hiding, or changing the names of worksheets.
3. Inserting new worksheets or chart sheets.
4. Moving or copying worksheet to another workbook.
5. In PivotTable reports, displaying the source data for a cell in the data area, or displaying page field pages on separate worksheets.
6. For scenarios, creating a scenario summary report.
7. In the Analysis Toolbar, using the analysis tools that place results on a new worksheet.
3. To prevent other users from removing workbook protection, in the Password (optional) box, type a password, click OK, and then retype the password to confirm it.

Allow cells to be edited in a protected worksheet
When you protect a worksheet, all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the worksheet. Windows
1. Moving, resizing, or closing the windows.
2. Changing the size and position of the windows for the workbook when the workbook is opened

· Changing the size and position of the windows for the workbook when the workbook is opened