ProtectScenarios Property
True if the worksheet scenarios are protected. Read-only Boolean.
Example
This example displays a message box if scenarios are protected on Sheet1.
If Worksheets("Sheet1").ProtectScenarios Then _
MsgBox "Scenarios are protected on this worksheet."