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!
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: www.asap-utilities.com/
Regards,
Bob--
VETcalc
------------------------------------------------------------------------
VETcalc's Profile: www.excelforum.com/member.php...oamp;userid=13078
View this thread: www.excelforum.com/showthread...hreadid=516905
- Apr 13 Sun 2008 20:43
How do I protect multiple sheets at one time?
close
全站熱搜
留言列表
發表留言
留言列表

