| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Protect/unprotect all worksheets
Is there a way to easily unprotect all the worksheets in a workbook? For
example, I have a workbook with 20 worksheets (one for each employee). The worksheets have been individually protected (except for the select cells into which I enter data. Now with the new year, I would like to unprotect all the worksheets so I can change the (previously protected) field that contains the year and then reprotect all the worksheets. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| maximum number of worksheets | Excel Worksheet Functions | |||
| How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
| Sort/Link Worksheets | Excel Worksheet Functions | |||
Threaded Mode
