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.
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.
No comments:
Post a Comment