Protecting Workbook Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top