Prevent changes to a scenario

Microsoft Office Excel 2003

Show All Show All

Prevent changes to a scenario

  1. On the Tools menu, click Scenarios.
  2. In the Scenarios box, click the name of the scenario.
  3. Click Edit.
  4. Do one of the following:
    • To prevent others from making changes to your scenarios, select the Prevent changes check box.
    • To remove a scenario from the list in the Scenario Manager dialog box, select the Hide check box.

  5. Click OK.
  6. In the Scenario Values dialog box, click OK, and then click Close.
  7. On the Tools menu, point to Protection, and then click Protect Sheet.
  8. Select the Protect worksheet and contents of locked cells check box, and make sure the Edit scenarios check box is clear.

Note  You can add scenarios when a worksheet is protected, but you cannot edit or delete existing scenarios while a worksheet is protected unless you clear the Prevent changes check box in the Edit Scenario dialog box. You can still edit the values in changing cells on the worksheet unless the cells are locked.