+ Reply to Thread
Results 1 to 1 of 1

Macro for printing

  1. #1
    Registered User
    Join Date
    10-08-2013
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2007
    Posts
    1

    Macro for printing

    Hi, I am new to Marcros and I need some help please. I created the attached spreadsheet. The Input tab is the one that I will be adding new details to and the Output tab will pull the information from the Input tab. I have a drop down on cell C17. By selecting diferent values there the information on the Output tab will change. The values under the dropdown are the values in column A on the Input tab. I need to assign a Macro (I think Macro is what I need) to the Print button that is located on F2 on the Output tab. I managed to create a Macro for printing the curent worksheet. But I need a Macro for printing multiple worksheets. For example, if I input information on rows 4 to 10 on the Input Tab, I would like to be able to print the Output worksheet for all of them together instead of selecting 4 on the C17 dropdown, print, then selecting 5 on the dropdown, print and so on until the last one I have updated. I hope I am explaining this well. In other words, when clicking on the print button I would like to see an option to select from 4 to 10 for example and then everything to print together.

    Please let me know if further clarification is needed. Many thanks.
    Attached Files Attached Files

+ 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] Macro for auto printing. macro printing at same time 17:30 but do not repeat.
    By aburger in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2013, 09:16 AM
  2. Disabling Printing ability of a sheet unless printing from a macro
    By cadamhill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2012, 04:41 AM
  3. Printing Macro-How can I make my print macro force excel
    By chris_mayer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2006, 09:26 PM
  4. [SOLVED] printing using a macro
    By John in forum Excel General
    Replies: 1
    Last Post: 06-14-2006, 08:25 AM
  5. [SOLVED] Macro Printing
    By Dave in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-24-2005, 01: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