| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I protect multiple sheets at one time?
I have a workbook which has many users. There are over 20 worksheets in
which I have formulas which need to be locked. The only way I can find to protect the formulas is to protect each sheet individually, which is very time consuming and a nightmare for editing/updates. Protecting the workbook does not work because I only want certain cells locked, not all of them...Am I missing an easier way? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I protect multiple sheets at one time?
There is a FREE Plug-in for Excel called ASAP. This is a fantastic program that performs many additional and enhance task. Using this program, you would select Sheets from the Menu and then select Protect All Sheets. You can get further info at: http://www.asap-utilities.com/ Regards, Bob -- VETcalc ------------------------------------------------------------------------ VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078 View this thread: http://www.excelforum.com/showthread...hreadid=516905 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time sheets | Excel Worksheet Functions | |||
| how do i protect multiple worksheets | Excel Discussion (Misc queries) | |||
| How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
| How do I protect formula cells on multiple sheets? | Excel Worksheet Functions | |||
| Time Sheets | Excel Worksheet Functions | |||
Linear Mode
