Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro finishes faster when left clicking during execution
Dear all,
Excel 2000. Could anyone please explain this. I have a large workbook with several worksheets, several links and loads of macros etc One of the macros for some reason executes twice as fast if I left click with the mouse during execution. Why is that? Is there a way to build a left click simulation into the macro? -- Regards, Martin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro finishes faster when left clicking during execution
It would really depend on when you;re clicking. In my expereince of Excel, if
you left click whilst the sheet is caluclating it can speed it up or almost complete it instantly. If this is what it is, the code would be trying to complete the line that forced the calculation, hence not being able to also left click at the same time. HTH. "Martin" wrote: Dear all, Excel 2000. Could anyone please explain this. I have a large workbook with several worksheets, several links and loads of macros etc One of the macros for some reason executes twice as fast if I left click with the mouse during execution. Why is that? Is there a way to build a left click simulation into the macro? -- Regards, Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can my macro run faster ? | New Users to Excel | |||
Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) | |||
Pausing procedure until worksheet finishes calculating | Excel Programming | |||
Excel code to Wait until Word finishes printing before closing | Excel Programming | |||
faster macro | Excel Programming |