excel vba protect scenarios code example
Example: excel vba protect scenarios
' Apply worksheet scenario protection only
Sheets("Sheet1").Protect Password:="myPassword", _
DrawingObjects:=False, _
Contents:=False, _
Scenarios:=True
' Apply worksheet scenario protection only
Sheets("Sheet1").Protect Password:="myPassword", _
DrawingObjects:=False, _
Contents:=False, _
Scenarios:=True