Question : excel vba protect scenarios
Answered by : vastemonde
' Apply worksheet scenario protection only
Sheets("Sheet1").Protect Password:="myPassword", _ DrawingObjects:=False, _ Contents:=False, _ Scenarios:=True
Source : https://exceloffthegrid.com/vba-code-worksheet-protection/#Protect_objects | Last Update : Fri, 02 Apr 21