• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1059
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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