+ Reply to Thread
Results 1 to 2 of 2

Print Sheets Identified by Checkbox

  1. #1
    Registered User
    Join Date
    10-14-2008
    Location
    Portland OR
    Posts
    1

    Print Sheets Identified by Checkbox

    Hell0!

    I have created a workbook of 30 or so worksheets and I am trying to create a macro that will allow the user to select all the worksheets they want to print via a table of contents with checkboxes.

    This is what I have so far... kinda works but only prints the first worksheet checked. Any suggestions?

    Please Login or Register  to view this content.
    Thanks Yall
    Last edited by VBA Noob; 10-14-2008 at 04:34 PM. Reason: Added code tags as per forum rules

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Woods,

    Welcome to the forum. Please use code tags as per forum rules below.

    This link may be of interest

    http://spreadsheetpage.com/index.php...eets_to_print/

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ 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. Setting Print Area across multiple sheets?
    By tekman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-21-2011, 10:40 PM
  2. Print sheets with cell argument
    By jwskibum in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-28-2011, 09:02 PM
  3. Print "Dynamic" Sheets if cell =
    By DJarqus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2008, 04:54 AM
  4. Print visible sheets
    By smj276 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2007, 10:47 PM
  5. Print Multiple Sheets On One Page
    By outthere in forum Excel General
    Replies: 3
    Last Post: 07-25-2007, 02:40 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