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