View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tiah
 
Posts: n/a
Default 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