| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write the result of a formula only once then lock it
I am creating a worksheet where fields are updated dynamically using a dde,
once the result of a formula is calculated it brings about a certain condition in one other part of the sheet example: IF(AI91="LONG","L",IF(AJ91="SHORT","S","")) Since the fields that this formula observes are dynamically updated the condition might change, but since I am only interested in the first occurance i wanted to lock the result of the first time a calculation is done, is it possibile? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Write the result of a formula only once then lock it
Hi
see your other post -- Regards Frank Kabel Frankfurt, Germany "investor" schrieb im Newsbeitrag ... I am creating a worksheet where fields are updated dynamically using a dde, once the result of a formula is calculated it brings about a certain condition in one other part of the sheet example: IF(AI91="LONG","L",IF(AJ91="SHORT","S","")) Since the fields that this formula observes are dynamically updated the condition might change, but since I am only interested in the first occurance i wanted to lock the result of the first time a calculation is done, is it possibile? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Write macro to lock selected sheet when run | Excel Discussion (Misc queries) | |||
| lock cells based on formula result | Excel Discussion (Misc queries) | |||
| Why do I get #NA as my result when I write a vlookup formula? | Excel Worksheet Functions | |||
| IF RESULT OF FORMULA IS 0 WRITE EXTIMATOR | Excel Worksheet Functions | |||
| Question: Cell formula or macro to write result of one cell to another cell | Excel Programming | |||
Linear Mode
