Protecting formulas in a workbook
 

How do you protect cells with formulas in a workbook without keeping
changes from being made by other people who are sharing the workbook?

In other words. I have inserted formulas into hundreds of worksheets
that are going to be shared. I don't want the calculations to be lost
if someone happens to push the wrong keys. Several people will be
sharing these worksheets and will need to change numbers in them, but I
want to protect the formulas. Is this possible?

Thank you ahead of time. :)


--
calimari


------------------------------------------------------------------------
calimari's Profile: http://www.excelforum.com/member.php...o&userid=24537
View this thread: http://www.excelforum.com/showthread...hreadid=384948

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

You can unlock all your cells. Then hit Edit--Go to--Special--Formulas
and lock those cells. Then protect...

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"calimari" wrote in
message ...

How do you protect cells with formulas in a workbook without keeping
changes from being made by other people who are sharing the workbook?

In other words. I have inserted formulas into hundreds of worksheets
that are going to be shared. I don't want the calculations to be lost
if someone happens to push the wrong keys. Several people will be
sharing these worksheets and will need to change numbers in them, but I
want to protect the formulas. Is this possible?

Thank you ahead of time. :)


--
calimari


------------------------------------------------------------------------
calimari's Profile:
http://www.excelforum.com/member.php...o&userid=24537
View this thread: http://www.excelforum.com/showthread...hreadid=384948

Thank you! Very much appreciated. ;)


--
calimari


------------------------------------------------------------------------
calimari's Profile: http://www.excelforum.com/member.php...o&userid=24537
View this thread: http://www.excelforum.com/showthread...hreadid=384948

Is there a way to copy a worksheet and create a hundred more without
having to paste them one at a time?


--
calimari


------------------------------------------------------------------------
calimari's Profile: http://www.excelforum.com/member.php...o&userid=24537
View this thread: http://www.excelforum.com/showthread...hreadid=384948