Activesheet.Printpreview behind my Userform

Posted on 2007-08-07
Last Modified: 2013-12-26

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

Question by:gbergsma
    LVL 85

    Accepted Solution

    Have you tried using something like:

      Me.Show False


    Author Comment

    Thanks for the quick answer. Maximising the App window was also required, but now its all good!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now