Q: How to use VBA to launch the PRINT pop up?

[peter_z]

Hey Guys

I am just wondering what the code is to launch the print pop up allowing the user to select the printer they want to use then print themselves?

i.e this page

Thanks a lot in advance for your help!

 

[Michael M]

try

Application.Dialogs(xlDialogPrint).Show

 

[Leith Ross]

Hello Peter,

This line of code will bring up the dialog...

    Application.Dialogs(xlDialogPrint).Show

Sincerely,
Leith Ross

 

[peter_z]

you guys are awesome!, cheers works perfect!