How to show print dialog box and print preview on same screen?
<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>