I am trying to emulate Ctrl-P in Excel 2013 where the print dialog box is shown on the left with the print preview on the right.
(Although where the preview displays, I always have to click "Show Print Preview" first. I can't find a way to force the preview to show every time).
I tried the following:
Application.Dialogs(xlDialogPrint).Show
This shows the old style dialog box where you need to click the "Preview" button
ActiveSheet.PrintPreview
This shows the preview but doesn't allow the printer to be changed from the same screen.