Results 1 to 14 of 14

Macro to print multiple sheets

Threaded View

  1. #1
    Registered User
    Join Date
    06-17-2011
    Location
    TN
    MS-Off Ver
    Excel 2003
    Posts
    11

    Macro to print multiple sheets

    I have a spreadsheet set up with multiple worksheets. I have one worksheet (Form tab) created that will pull data from the other sheets that I want to print. Have macros set up to gather sheets which put the sheet names in a combobox and to printform. Can't get the print feature to work correctly. It only prints the sheet that's selected but it's not cycling properly. Any assistance someone can provide will be greatly appreciated. Not sure what's going wrong. Same code I use every year.

    Sample spreadsheet attached
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to Print Multiple Sheets to Single PDF
    By LEber in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-09-2013, 09:52 AM
  2. Macro to Print Multiple (Selective) Excel sheets to One PDF
    By volfan212 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2013, 03:42 PM
  3. MACRO to print multiple sheets to multiple PDF's with different names
    By bruwer in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-15-2010, 07:03 AM
  4. Apply Print Settings to Multiple Sheets via MACRO
    By ShaneBell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2009, 08:48 PM
  5. Macro: To print multiple sheets in a folder
    By NZMax in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-16-2009, 01:07 AM

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