Printer macro

Hello Everyone:

I am trying to write a macro that will be linked to a button. When you click the button the printer dialog box will appear, printing a different sheet. The user should be able to select to change the number of copies printed etc. and then click “ok” and the macro should return to the first sheet. The problem I have is that after the printer dialog box opens. I cannot change back to the first sheet. And allow the user to make changes to the print options?

Any Ideas?

Thanks

Art W.

i am not sure that i really understand what you want to do

Art W.

The "Print Dialog Box" opens in modal mode. Till the time it is open, I am afraid, you cannot navigate to any other sheets. What I would recommend is to finish printing and then navigate to the next sheet.

Hope I have understood your query correctly?

Sid