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.