Expand Minimize

Worksheet.ProtectScenarios Property (Excel)

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

expression .ProtectScenarios

expression A variable that represents a Worksheet object.

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

If Worksheets("Sheet1").ProtectScenarios Then _ 
 MsgBox "Scenarios are protected on this worksheet."
Show:
© 2014 Microsoft