How can I protect several sheets in a workbook simultaneously?
 

I don't want to protect the whole book with a password, but certain cells on
each of the 52 pages in the book. I sometimes need to make changes to the
sheets, so I need to unprotect them all and reprotect when the changes have
been made. Is there a way of doing this across all the sheets rather than
going into each one individually? Running on Excel 2003.

You'll need to use a macro. Look he

http://groups-beta.google.com/group/...programming/br
owse_frm/thread/4edf513d54f2d1eb/35629d67a3037b99

This is a pretty frequently asked question - you can find the above, and
other answers, in the archives:

http://groups.google.com/advanced_gr...ugroup=*excel*


In article ,
"Fran crisp" <Fran wrote:

I don't want to protect the whole book with a password, but certain cells on
each of the 52 pages in the book. I sometimes need to make changes to the
sheets, so I need to unprotect them all and reprotect when the changes have
been made. Is there a way of doing this across all the sheets rather than
going into each one individually? Running on Excel 2003.