B BannerBrat Feb 5, 2004 #1 I know I can protect individual worksheets and limit the areas that can be edited. Can I do this for an entire workbook? How?
I know I can protect individual worksheets and limit the areas that can be edited. Can I do this for an entire workbook? How?
D Debra Dalgleish Feb 5, 2004 #2 You can use a macro to protect each sheet in a workbook. For example: Sub ProtectAllSheets() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Protect DrawingObjects:=True, _ Contents:=True, Password:="pwd" Next ws End Sub
You can use a macro to protect each sheet in a workbook. For example: Sub ProtectAllSheets() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Protect DrawingObjects:=True, _ Contents:=True, Password:="pwd" Next ws End Sub
