Inserting rows into worksheets that are protected
Here is all the code you can put to protect in 2003
Worksheets("Clarence") .Protect DrawingObjects:=False, _
Contents:=True, Scenarios:= False, AllowFormattingCells:=True,
_
AllowFormattingColumns:=True, AllowFormattingRows:=True, _
AllowInsertingColumns:=True, AllowInsertingRows:=True, _
AllowInsertingHyperlinks:=True, AllowDeletingColumns:=True, _
AllowDeletingRows:=True, AllowSorting:=True,
AllowFiltering:=True, _
AllowUsingPivotTables:=True
|