LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
paste formulas between workbooks without workbook link ron Excel Discussion (Misc queries) 3 April 22nd 23 08:11 AM
Protecting A Workbook from being saved/written over Lauren Excel Discussion (Misc queries) 2 June 27th 05 06:24 PM
Locking and Protecting and NOT displaying formulas RTP Excel Discussion (Misc queries) 2 May 4th 05 11:17 PM
How to copy formulas from one workbook to another Confused Excel Discussion (Misc queries) 1 February 18th 05 05:07 PM
Formulas not working after transfering to new workbook Mark Jackson Excel Worksheet Functions 5 December 15th 04 06:17 PM


All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"