Protecting formulas in a workbook

[calimari]

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.

 

[Anne Troy]

Try this:
http://www.officearticles.com/excel/cell_locking_in_microsoft_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]

Thank you! Very much appreciated. ;

 

[calimari]

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