+ Reply to Thread
Results 1 to 3 of 3

PrintOut method printing all pages, not the ones I want

  1. #1
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    PrintOut method printing all pages, not the ones I want

    Hey everyone,

    With the help of shg I was able to create a neat tool that automatically creates shipping labels based on certain in ranges. Awesome. It uses two tabs and then generates a new tab for each label. Also awesome.

    Well now, I want to add a "Print labels" button so they can easily print these out. I thought it would be very simple as I just used

    Please Login or Register  to view this content.
    since I do not want the template and the lists of information included. When I click the button it sends them to the printer but it sends everything, not just the shipping labels! Help please!?
    Last edited by ericbartha; 12-18-2014 at 06:53 PM.

  2. #2
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    Re: PrintOut method printing all pages, not the ones I want

    I did not full understand the Syntax before, but I think now I do. I want to control which worksheets (or "tabs") are printed as each one represents a shipping label, not the pages, as PrintOut From does.

  3. #3
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    Re: PrintOut method printing all pages, not the ones I want

    Trying to delete this thread but unsure how.

+ 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 out certain pages in an excel sheet by PrintOut Method
    By bhayu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-13-2014, 07:11 PM
  2. Printing different "file types" from PrintOut method?
    By PetersBase in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2011, 09:22 AM
  3. Deselecting sheets after the PrintOut method
    By johnhildreth@charter.net in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2005, 08:05 PM
  4. Problems with Printout Method
    By in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2005, 01:06 PM
  5. [SOLVED] Printout method: in color, duplex
    By michael_mcclellan@hotmail.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2005, 05:06 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