• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 931
  • Last Modified:

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
0
gbergsma
Asked:
gbergsma
1 Solution
 
Rory ArchibaldCommented:
Have you tried using something like:

   Me.Hide
  ActiveSheet.PrintPreview
  Me.Show False

Regards,
Rory
0
 
gbergsmaAuthor Commented:
Thanks for the quick answer. Maximising the App window was also required, but now its all good!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now