View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Hash@example.org is offline
external usenet poster
 
Posts: 24
Default Right Mouse click advances macro?

All -

I have several macros that each input and parse a lot of data and then
format the result. Each takes a long time to run. I watch that
hour-glass for a good while, but the macros in the end do successfully
run.

I've discovered that if after several minutes I do a right-mouse-click
that that the macros immediately jump to the next step, which is a user
input.

So it occurs to me that: one, there's needless idle time going on that I
don't know how to find, and two, that if I can "program in" a
right-mouse click before the input, I'll be minutes ahead.

I apologize for not knowing how to Google this in 10 words or less. Can
anyone provide insight into what's going on?

....best, Hash