Application.Dialogs(xlDialogPrinterSetup).Show
I used the above in an Excel2000 macro and it does pop up the printer dialog box. However, when I select a new printer on the list and click "setup" the setup is for the printer that was selected when the box opened. In order to get the setup for a new printer I have to select a new printer and click OK (the form closes). Next time I go into the form, the setup button will be for the new printer.
Thank You
I used the above in an Excel2000 macro and it does pop up the printer dialog box. However, when I select a new printer on the list and click "setup" the setup is for the printer that was selected when the box opened. In order to get the setup for a new printer I have to select a new printer and click OK (the form closes). Next time I go into the form, the setup button will be for the new printer.
Thank You
