Protection

B

BannerBrat

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

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
 
Top