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