+ Reply to Thread
Results 1 to 2 of 2

Closing Print Preview

  1. #1
    Registered User
    Join Date
    04-29-2017
    Location
    London
    MS-Off Ver
    2016 Professional
    Posts
    50

    Closing Print Preview

    Hello All

    How can i determine if the user has closed the Print Preview window without printing? I am using the following code to display Excel Print Preview. If the user closes Print Preview without printing i would like to exit the sub.

    Please Login or Register  to view this content.

    Thanks

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,358

    Re: Closing Print Preview

    You could check the Print queue for items present.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro slows down when I print/print preview/page break a sheet
    By Grug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2015, 08:59 PM
  2. Set print area of selected range then print preview if ok then print the document!
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 07:10 AM
  3. [SOLVED] How to prevent "Print Preview" from slowing down your macros after viewing Print Preview
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2014, 02:54 PM
  4. page break preview vs print preview do not match
    By chadgar24 in forum Excel General
    Replies: 1
    Last Post: 05-16-2012, 11:32 AM
  5. VBA Macro shows Print Preview page: How to auto-maximize the Print Preview?
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2010, 04:48 PM
  6. Print Preview Doesn't Match Page Break Preview
    By mik7585 in forum Excel General
    Replies: 0
    Last Post: 06-01-2009, 11:32 AM
  7. Replies: 2
    Last Post: 04-05-2006, 09:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1