Worksheet protection

[greyseal]

G'day. I maintain a monthly roster in Excel. There are 20 - 22 worksheets, depending on the number of days in the month, that require protection. Is there any simple way to protect multiple worksheets at the same time, or do they need to be done independently?

Looking forward to your replies.

 

[mrnacar]

Try

http://www.ozgrid.com/VBA/excel-worksheet-protect-all.htm

 

[Michael M]

Hi
try these

Sub unprotect_all_ws()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Unprotect "password"
Next ws
End Sub


Sub protect_all_ws()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Protect "password"
Next ws
End Sub

Change "password" to suit