Excel Printing.

[kpetursson]

Is there a way to have VBA open the print dialog box, so the user may select the printer.

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=True, Collate:=True

The printout method doesn't seem to have this feature. I know I can set the desired printer, but that assumes I know the name of the printer. I want the code to be usable on several machines with different prints, and their names are not know to me.

When this VBA code brings up the print preview window, the print... button just prints the file without bring up the expected print dialog.

Any help is greatly appriciated.


Kevin Petursson

 

[kpetursson]

I found an anwaser Thanks

Application.Dialogs(xlDialogPrint).Show

Thanks

Kevin Petursson