Share via

Scenario Object Members

  • Article
Excel Developer Reference

Represents a scenario on a worksheet.

Methods

  Name Description
Bb225639.methods(en-us,office.12).gif ChangeScenario Changes the scenario to have a new set of changing cells and (optionally) scenario values.
Bb225639.methods(en-us,office.12).gif Delete Deletes the object.
Bb225639.methods(en-us,office.12).gif Show Shows the scenario by inserting its values on the worksheet. The affected cells are the changing cells of the scenario.

Properties

  Name Description
Bb225639.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb225639.properties(en-us,office.12).gif ChangingCells Returns a Range object that represents the changing cells for a scenario. Read-only.
Bb225639.properties(en-us,office.12).gif Comment Returns or sets a String value that represents the comment associated with the scenario.
Bb225639.properties(en-us,office.12).gif Hidden Returns or sets a Boolean value that indicates if the scenario is hidden.
Bb225639.properties(en-us,office.12).gif Index Returns a Long value that represents the index number of the object within the collection of similar objects.
Bb225639.properties(en-us,office.12).gif Locked Returns or sets a Boolean value that indicates if the object is locked.
Bb225639.properties(en-us,office.12).gif Name Returns or sets a String value representing the name of the object.
Bb225639.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225639.properties(en-us,office.12).gif Values Returns a Variant array that contains the current values of the changing cells for the scenario.