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!

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