I write very basic macros. I'm old basic programer. My macros organize
and print stuff from various sheets.

Now I need to stop the macro on a particular sheet, have the user fill
in some stuff on that sheet, then continue the macro. How do I do that?

Thanks

John

Essentailly it will be two macros. The first macro does it's stuff and takes
you to the next sheet. It can then use either a button or an on change event
(button would be my preference) to continue the processing. By using the
button you give your end user the ultimate control over what is done and
when.
--
HTH...

Jim Thomlinson


"John" wrote:

I write very basic macros. I'm old basic programer. My macros organize
and print stuff from various sheets.

Now I need to stop the macro on a particular sheet, have the user fill
in some stuff on that sheet, then continue the macro. How do I do that?

Thanks

John

I guess this can work. The sheet is a form (worksheet) which is printed
and cleared and then used to generate the next report. Very rarely the
user needs to input a little bit before printing. Mostly the data is
gathered from other sheets and the form filled and printed automaticlly.

hmmmmm Since I mark the sheets "processed" after processing them I could
have the user print the current sheet then just run the macro again.

It isn't elegant but it will work I guess.

I tried to use the ShowDataForm function but it was too complicated.
Apparently the data form has to be set up just right to work.

John


Essentailly it will be two macros. The first macro does it's stuff and takes
you to the next sheet. It can then use either a button or an on change event
(button would be my preference) to continue the processing. By using the
button you give your end user the ultimate control over what is done and
when.