View Single Post
  #1   Report Post  
calimari
 
Posts: n/a
Default 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