Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect formulas only
Hi -
I have a massive spreadsheet with formulas in it and variable input data. I don't want to protect the whole worksheet because there is variable data that effects formula output. I wondered.... is there a way to protect my formulas only so that I don't fat finger and ruin a formula (that has taken time and consideration) and that I can only change the variable data input? For example, if I have a formula such that if Q1 actual sales are greater than or equal to 110% of Q1 Plan then the customer gets a reward of 5% of Q1 actual sales. So I don't want to ever change the formula, but I might want to change Q1 actual data if it changes due to adujustments or incorrect input on my part. I tried copy, paste special, formulas, but that did not freeze the formula cell. Please let me know. Thank you very much. -- Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect my formulas! | Excel Worksheet Functions | |||
How do I protect formulas from being deleted? | Excel Worksheet Functions | |||
Protect Formulas | Excel Worksheet Functions | |||
How do I protect only formulas in Excel? | Excel Discussion (Misc queries) | |||
protect formulas | Excel Programming |