Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Locking formulas
I am creating an order form in Excel for clients. I have protected the text
in selected cells so the cells can't be accessed. I also want to lock the formulas in other selected cells so the formulas can't be deleted, changed, etc. How can this be done? |
#2
|
|||
|
|||
Margaret, unless I am missing something, protect the cells with the formulas
the same as you did for the text -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Margaret DS" <Margaret wrote in message ... I am creating an order form in Excel for clients. I have protected the text in selected cells so the cells can't be accessed. I also want to lock the formulas in other selected cells so the formulas can't be deleted, changed, etc. How can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
locking formulas | Excel Discussion (Misc queries) | |||
Locking and Protecting and NOT displaying formulas | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
Locking Sheet names in formulas | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |