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

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.

--
Regards,
Tom Ogilvy


"What-a-Tool" wrote in message
news:N8oid.58301$UA.810@lakeread08...
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

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