Worksheet.ProtectScenarios Property

  • Article
Excel Developer Reference

True if the worksheet scenarios are protected. Read-only Boolean.

Syntax

expression.ProtectScenarios

expression   A variable that represents a Worksheet object.

Example

This example displays a message box if scenarios are protected on Sheet1.

Visual Basic for Applications 
  If Worksheets("Sheet1").ProtectScenarios Then _
    MsgBox "Scenarios are protected on this worksheet."

See Also