Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default controlling excel recalculation in VBA?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I stop a recalculation in Excel? tengel Excel Discussion (Misc queries) 6 November 7th 08 11:04 PM
Excel 2007 Recalculation Bug [email protected] Excel Programming 2 November 6th 06 07:49 PM
Excel formulas and recalculation Peter Excel Discussion (Misc queries) 3 June 8th 05 10:17 PM
Excel recalculation R Ormerod Excel Discussion (Misc queries) 3 May 4th 05 01:56 PM
Forced recalculation in Excel Claude Excel Programming 1 October 16th 03 10:28 AM


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"