View Single Post
  #1   Report Post  
Fran crisp
 
Posts: n/a
Default 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.