Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks to both for the help. I was able to get the ontimer working,
but did have to workaround 2 Excel quirks: 1) Application.CalculationInterruptKey = xlAnyKey seems to be changed to xlNoKey (at least temporarily) after a large paste. I had to include the Application.CalculationInterruptKey = xlAnyKey statement inside my timer sub. I suspect this is the same "optimization" that MS did that prevents interruption after paste in Automatic mode. I'm hoping MS will be nice and create a registry flag to shut this off. 2) I lose the clipboard during a recalc. I had to check for Application.CutCopyMode = 0 before executing the recalc. I have a 3rd bug that I haven't been able to fix. The "end" mode (when the END key is pressed) resets upon a recalc as well. Is there a vba property that can read the "end" state? Googling "end" returns way to many irrelevant results. -MVL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I stop a recalculation in Excel? | Excel Discussion (Misc queries) | |||
Excel 2007 Recalculation Bug | Excel Programming | |||
Excel formulas and recalculation | Excel Discussion (Misc queries) | |||
Excel recalculation | Excel Discussion (Misc queries) | |||
Forced recalculation in Excel | Excel Programming |