+ Reply to Thread
Results 1 to 4 of 4

VBA print options

  1. #1
    Forum Contributor
    Join Date
    01-21-2017
    Location
    England
    MS-Off Ver
    2007
    Posts
    409

    VBA print options

    Hi I have a simple code:

    Please Login or Register  to view this content.
    However instead of printing I want it to come up the with printer options so each time I can select the correct printer in the office. See picture below.

    print.JPG

    Cheers

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: VBA print options

    .
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    01-21-2017
    Location
    England
    MS-Off Ver
    2007
    Posts
    409

    Re: VBA print options

    Hi thank you, but how do I get it to print sheet "Print" not the sheet the button is on

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: VBA print options

    .
    You posted an image of the Printer Dialog Window ... so ... I presumed that was what you were seeking. Although convoluted you can :

    You select the PRINT RANGE / PAGES (From / To)

    Each sheet has a number assigned to it. Look in the VBE where the sheets are listed to determine the sheet number.


    I also presume you can use the PrinterDialogWindow to select the desired printer, close the window and continue using your original macro to print
    the desired sheet.

    ===========================

    However, if you review Chip Pearson's website you can learn how to use a small macro to see what printers are available and select one
    as active, then you should be able to continue using your original macro for printing. Here is the link to Chip's website :

    http://www.cpearson.com/excel/GetPrinters.aspx

    The example .XLS zipped file is down the bottom of the page or you can download it here as the attachment.

    ===========================

    You can also hardcode the desired printer in your macro (making it the active printer) and continue on with your original macro.

    This macro will bring up a small window where you can select the desired printer (hopefully it will show your networked printers), then brings up the PRINT PREVIEW window,
    then prints the sheet you have hardcoded into the macro (your original sheet name).

    Please Login or Register  to view this content.
    ===========================

    One of these approaches will work ...
    Attached Files Attached Files
    Last edited by Logit; 08-12-2018 at 07:22 PM.

+ 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. [SOLVED] Print Options
    By majime01 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-18-2015, 01:42 AM
  2. [SOLVED] VBA to reset Print Options
    By chasoe in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-31-2015, 09:58 PM
  3. [SOLVED] workbook print options
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 10-29-2012, 03:37 AM
  4. print options
    By don923 in forum Excel General
    Replies: 3
    Last Post: 02-26-2008, 11:15 AM
  5. Customized Print Options
    By hammerlife in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2007, 09:51 AM
  6. Replies: 1
    Last Post: 09-23-2005, 02:05 PM
  7. [SOLVED] print options
    By andrew a in forum Excel General
    Replies: 1
    Last Post: 08-29-2005, 05:05 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