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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not execute a button's code when another macro simulates mouse movements & clicks 2
Making the macro's execution faster 2
Macro execution changes filename reference for all macros 1
Implement a progress bar when the macro run inside another workboo 2
label control from macro 11
Macro Runs Twice 3
execution speed issue when closing files 5
Buttons re-assigned themselves to the right macro name but in Book 1

Back
Top