gbergsma
asked on
Activesheet.Printpreview behind my Userform
Hi,
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
G
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
G
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER