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

it helps if you post the code

<Hash@example.org> wrote in message news:YQ1Kf.98297$4l5.60542@dukeread05...
> 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

Perhaps calculation is causing the problem - the click could be interrupting
the calculation



at the top of the macro try

Application.Calculation = xlManual

and at the end

Application.Calculation = xlAutomatic

--
Regards,
Tom Ogilvy

<Hash@example.org> wrote in message news:YQ1Kf.98297$4l5.60542@dukeread05...
> 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