Protecting Workbook Data

[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.

 

[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