VBA to show excel Menu File / Print screen

[Shadkng]

Hi, Is there code to show the print screen as if you went to file and print from the menu? I tried the "(xlDialogPrint).Show", but that doesn't show all of the options such as fit to page, landscape, etc. Thanks

 

[jim may]

Can you Use keyboard combination - Ctl+P

 

[Jaafar Tribak]

Try this :

Application.CommandBars.ExecuteMso ("PrintPreviewAndPrint")

 

[Jaafar Tribak]

Or if you want to show all of the options such as fit to page, landscape, etc try this instead :

[/COLOR]Application.Dialogs(xlDialogPageSetup).Show[COLOR=#333333]