Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application is already Calculating during a "Change" event
I have a workbook with a "change" event, which updates the formats of other
cells in the workbook. For example, another cell may turn red to indicate that its value is no longer valid with the new value of the changed cell. Another workbook links to this workbook, but whenever it is open and automatic calculation is on, my "on change" macro crashes. I've found that I can tell when this is going to happen with the "Application.CalculationState" property. If this property is set to xlCalculating, then the macro is going to crash and I could bail out, but I still need this macro to complete. I've already tried Application.Wait and Application.OnTime, but Excel seems to ignore these when the CalculationState property equals xlCalculating. According to the call stack, the user definded function in the file that links to mine is the first thing called, then "[<Non-Basic Code]", then my change event. Is there any way to force the calculation to complete before continuing, or pause the macro and allow it to complete, or call the logic of my change event through a different event? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
"change" event for validation/pick lists | Excel Programming | |||
"Dragging Chart Markers to Change Data" Event | Excel Programming | |||
Is there a "cell change" event? | Excel Programming |