Halting code for worksheet manipulation?

[What-a-Tool]

I have a project where a user fills a collection with worksheets that have
been selected for changes. The code then opens the worksheet, performs some
action on the worksheet, and then closes it. On close I wish to show a form
with several options for the user to select from.

My problem is getting the code to stop execution while each worksheet is
loaded. (worksheet should now be modal). I can make my form modal to stop
execution, but then can't touch the worksheet.
Is there a way that this could be done?

Thanks

--

/ Sean the Mc /

"Opinions are like flatulence - everyone loves the sound of their own, but
anyone else's usually just stinks !"
-anonymous

 

[Tom Ogilvy]

Not very robust, but you could have your macro end and then restart it using
the sheet events.

There isn't any built in support for pausing a macro for user input beyond
the refedit control on a userform (allows a user to select a range).

The usual approach is to control the interaction with a userform, using code
to update the sheet with data solicited on the userform.

 

[What-a-Tool]

There isn't any built in support for pausing a macro for user input beyond

the refedit control on a userform (allows a user to select a range).

Thanks - thats kinda what I suspected - time to think of another way to do
things.

--

/ Sean the Mc /

"Opinions are like flatulence - everyone loves the sound of their own, but
anyone else's usually just stinks !"
-anonymous