Results 1 to 8 of 8

Check box selection for sheet printing

Threaded View

  1. #1
    Registered User
    Join Date
    11-10-2015
    Location
    Peterborough
    MS-Off Ver
    2013
    Posts
    4

    Check box selection for sheet printing

    Hi

    I'm looking to add a front sheet to my parts workbook that will allow checkbox selection of the sheets to be printed when command button is pressed. The workbook has approximately 190 sheets so ctrl select becomes a pain!

    In my naivety I assumed that a command button that has the following would work:

    Private Sub CommandButton1_Click()
    
    If b2 = True Then
    PrintOut ("Sheet1")
    End If
    
    If b4 = True Then
    PrintOut ("Sheet2")
    End If
    
    If b6 = True Then
    PrintOut ("Sheet3")
    End If
    End Sub
    Clearly not as it does nothing! I'm new to the programming as you may guess! Any help gratefully received.
    Last edited by SimonDann; 11-10-2015 at 10:03 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Printing each filter selection
    By neofox in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-06-2015, 07:00 AM
  2. [SOLVED] VBA help password check then open form or sheet depending on option button selection
    By pjbassdc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2013, 06:35 AM
  3. Replies: 0
    Last Post: 07-18-2012, 03:57 AM
  4. 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
  5. printing a selection
    By Bart in forum Excel General
    Replies: 1
    Last Post: 06-02-2006, 04:30 PM
  6. Printing a selection of rows
    By Jbucks007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-18-2005, 03:25 AM
  7. how to check if user has made a selection on the sheet
    By chawla12amit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2005, 03:51 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