Hi Chip,

Thank you for your reply! I know how to get in to VB editor. Do I just
copy and paste this with minor changes (worksheet #s; unprotect or protect)?
How do I run it then?

Thanks

"Chip Pearson" wrote:

Only with a VBA macro:

Sub ProtectSheets()
Dim WS As Worksheet
For Each WS In Worksheets
WS.Protect ' or .Unprotect
Next WS
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"CheriT63" wrote in message
...
I find it tedious to have to unprotect each worksheet
individually when I
need to edit or update a spreadsheet. The same is true when I
want to
protect them again. Isn't there some way to do all worksheets
at the same
time?

Protecting the workbook as a whole is not a workable solution.
It restricts
things I don't want to restrict.