close

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

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()