Equivalent to clicking the Scenarios command from the Tools menu and then clicking the Edit button.
Syntax
SCENARIO.EDIT(scen_name, new_scenname, value_array, changing_ref, scen_comment, locked, hidden)
SCENARIO.EDIT?(scen_name, new_scenname, value_array, changing_ref, scen_comment, locked, hidden)
Scen_name is the name of the scenario that you want to edit.
New_scenname is the new name you want to give to the scenario.
Value_array is a horizontal array of values that you want to use for the scenario.
If value_array is omitted but changing_ref is specified, Scenario Manager uses the values in changing_ref as value_array.
Value_array must match the dimensions of changing_ref for the scenario being edit.
Changing_ref is a reference to cells you want to define as changing cells for a scenario.
Scen_comment is text specifying a descriptive comment for the scenario you want to edit.
Locked is a logical value that corresponds to the Prevent Changes check box in the Add or Edit Scenario dialogs boxes. If TRUE or omitted , prevents users from changing values in a scenario. If FALSE, users are allowed to make changes to the scenario. The locking will not become enabled until the sheet is protected with the Protect Sheet command from the Protection submenu on the Tools menu.
Hidden is a logical value that corresponds to the Hide check box in the Add or Edit Scenario dialog boxes. If TRUE, the scenario will be hidden from view from the users. If FALSE or omitted, the scenario will remain unhidden. The scenario will not become hidden until the sheet is hidden with the Hide command from the Window menu.
Related Functions
SCENARIO.GET Returns the specified information about the scenarios defined on your worksheet
SCENARIO.ADD Equivalent to clicking the Scenario Manager command on the Tools menu and then clicking the Add button
SCENARIO.DELETE Equivalent to clicking the Scenario Manager command on the Tools menu and then selecting a scenario and clicking the Delete button
Return to index