| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Warning when formula in a cell is changed
I am building a template and I cannot lock all the cells with formulas from
users. I do want to see when a formula in a specific cell has been changed from the original. Is there a way to do this with other formulas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Warning when formula in a cell is changed
Nope... Why do you need to allow users to change formulas? That seems like a
really bad idea. -- HTH... Jim Thomlinson "Lciotinga" wrote: I am building a template and I cannot lock all the cells with formulas from users. I do want to see when a formula in a specific cell has been changed from the original. Is there a way to do this with other formulas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Warning when formula in a cell is changed
Not with other formulas, but you can use a Worksheet_Change event macro to
tell you that the formula has been changed and to take whatever action you want. HTH Otto "Lciotinga" wrote in message ... I am building a template and I cannot lock all the cells with formulas from users. I do want to see when a formula in a specific cell has been changed from the original. Is there a way to do this with other formulas? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Warning when formula in a cell is changed
Perhaps place the same formula on a locked sheet and then Conditionally
format the cell in question to be red if the cells values are not the same? Lciotinga wrote: I am building a template and I cannot lock all the cells with formulas from users. I do want to see when a formula in a specific cell has been changed from the original. Is there a way to do this with other formulas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format changed when the details in cell changed | Excel Worksheet Functions | |||
| update formula in column when another cell formula is changed | Excel Worksheet Functions | |||
| With a formula in a cell, what is the warning symbol for? | Excel Discussion (Misc queries) | |||
| Help with a blank cell warning | Excel Worksheet Functions | |||
| How do I set a formula that indicates a if a cell value changed? | Excel Worksheet Functions | |||
Linear Mode
