Macro finishes faster when left clicking during execution

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top