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