Protecting Workbook Data

J

JPack

How can I let other users view and print a whole workbook but not make any changes to the workbook? I have been successful applying this to one sheet but have been unsuccessful at applying it to an entire workbook.
 
J

Jim Rech

You'd have to apply sheet protection to each sheet individually. A macro
can make that easier:

Sub a()
Dim WS As Worksheet
For Each WS In Worksheets
WS.Protect
Next
End Sub
 
Top