| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I protect a worksheet from being opened inside a workbook | Excel Discussion (Misc queries) | |||
| Numbering sheets in workbook | Excel Worksheet Functions | |||
| Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) | |||
| How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
| Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
Threaded Mode
