something like
for each ws in worksheets
if ws.name<"notthisone" _
and ws.name <"notthisoneeither" then
end if
ws.protect
next ws

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"mohavv" wrote in message
...
Hi,

Is there a way to protect all the sheets in a workbook in one go?
I've got 17-19 sheets (it varies).

I could create a macro, but how to handle the different number of
sheets?

Cheers,

Harold