+ Reply to Thread
Results 1 to 3 of 3

Create buttons to print defined print areas

  1. #1
    Registered User
    Join Date
    09-23-2014
    Location
    Seattle
    MS-Off Ver
    2010
    Posts
    25

    Create buttons to print defined print areas

    Hi,

    I'm hoping someone can help with a request I recently received. I used Jet Reports to build an inventory count sheet for my warehouse crew. I include the Quantity on Hand on the report, but have defined the print area to exclude this column. I'd like to include a button on the report that will give the inventory manager the option of printing the original report plus the Quantity on Hand column without having to redefine the print area for each sheet they run.

    In essence, I'm hoping for a button that redefines the print area and prints the report with the added column.

    Is that possible? Thanks.

  2. #2
    Forum Contributor
    Join Date
    04-23-2012
    Location
    Bradford PA
    MS-Off Ver
    Excel 2010
    Posts
    250

    Re: Create buttons to print defined print areas

    Quote Originally Posted by nwpassage View Post
    Hi,

    I'm hoping someone can help with a request I recently received. I used Jet Reports to build an inventory count sheet for my warehouse crew. I include the Quantity on Hand on the report, but have defined the print area to exclude this column. I'd like to include a button on the report that will give the inventory manager the option of printing the original report plus the Quantity on Hand column without having to redefine the print area for each sheet they run.

    In essence, I'm hoping for a button that redefines the print area and prints the report with the added column.

    Is that possible? Thanks.
    Can you provide a little more detail related to the original print area (i.e. its range) and the adjustment that you would like the button to add? Is the column always a "static" column or are they different columns? From what I gather there are multiple sheets do you need one for each sheet or do you want one button that allows you to choose which sheet?

  3. #3
    Valued Forum Contributor
    Join Date
    11-26-2012
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    419

    Re: Create buttons to print defined print areas

    Maybe something like this?

    Please Login or Register  to view this content.

+ 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 to print multiple print areas on one page.
    By morangeman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2015, 12:13 PM
  2. VBA code to print several print areas in one worksheet
    By ABSTRAKTUS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2010, 03:24 PM
  3. Save as PDF and email / User defined Sheets and Print Areas
    By alexq in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-16-2010, 04:19 PM
  4. How to print multiple print areas on the same page.
    By Dalilah in forum Excel General
    Replies: 5
    Last Post: 08-27-2008, 09:05 AM
  5. printing multiple print areas with a print dialog box
    By LHaro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-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