I am running a VBA program within Excel. I am opening my application modelsss so I can minimise the application window.
I want to show a print preview of my spreadsheet. I am using Activesheet.PrintPreview. The preview pane appears behind my Userform and I cannot interact with either - I have to terminate Excel.
I would like the preview page to show in front of my Userform, have the user view the preview, close it, and they end up back in the Userform.
Your advice appreciated