+ Reply to Thread
Results 1 to 5 of 5

Macro to enable user to preview print range

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,767

    Macro to enable user to preview print range

    I would like code to enable the user to preview the Print range and once previewed, then to print the range


    It would be appreciated if someone could assist me

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2406 Win 11 Home 64 Bit
    Posts
    23,982

    Re: Macro to enable user to preview print range

    change your range as required.

    Please Login or Register  to view this content.
    Once opened and happy, click print on the preview screen
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,767

    Re: Macro to enable user to preview print range

    Thanks for the help. I use a user form and the form hangs now when Print Preview is select. I now form to close once Print Preview is selected

    Please provide code to do this

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,548

    Re: Macro to enable user to preview print range

    If you have a Print Preview Button on your UserForm named "PrintPreview", you could use this for that button.
    Please Login or Register  to view this content.
    Attachment 650904

  5. #5
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,767

    Re: Macro to enable user to preview print range

    Thanks for the help

+ 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. Print preview for a User Form OR Select a printer from list of avaiable
    By TheHobbit81 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2019, 06:31 AM
  2. [SOLVED] Macro to open Print Preview & Print from Quick Access Toolbar
    By fastcar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2017, 04:58 PM
  3. Print Preview Tab and popup window so the user can select printer
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2015, 12:56 PM
  4. 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
  5. 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
  6. User Form freezes when I do Print Preview
    By JieJenn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2012, 12:55 PM
  7. 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

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