| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
| Protecting A Workbook from being saved/written over | Excel Discussion (Misc queries) | |||
| Locking and Protecting and NOT displaying formulas | Excel Discussion (Misc queries) | |||
| How to copy formulas from one workbook to another | Excel Discussion (Misc queries) | |||
| Formulas not working after transfering to new workbook | Excel Worksheet Functions | |||
Hybrid Mode
