+ Reply to Thread
Results 1 to 3 of 3

userform with checkbox to create single pdf from multi sheets

  1. #1
    Registered User
    Join Date
    01-08-2015
    Location
    England
    MS-Off Ver
    2010
    Posts
    3

    userform with checkbox to create single pdf from multi sheets

    Hi All

    I have created a series of worksheets in my workbook 74 to be exact, with a userform for printing. Each worksheet name is displayed on my userform with a checkbox next to it for printing. I have managed to setup a command button to print the selected worksheets which works fine but what i really need to do is print the selected checkboxes to a pdf using cutepdf writer.

    I have searched forums for days but had no luck finding the code.

    My worksheets are named RA1-RA47,MH1-MH12 & CO1-CO15. Which make up my 74. My checkboxes are named RA1P (P for Print) etc .......

    I have also noticed that the dpi quality needs to be set to 300 to print Pdf as opposed to 600 when i print to the local printer.

    Can anybody please assist in any way?

  2. #2
    Registered User
    Join Date
    01-08-2015
    Location
    England
    MS-Off Ver
    2010
    Posts
    3

    Re: userform with checkbox to create single pdf from multi sheets

    Anybody???

  3. #3
    Registered User
    Join Date
    01-08-2015
    Location
    England
    MS-Off Ver
    2010
    Posts
    3

    Re: userform with checkbox to create single pdf from multi sheets

    Anybody else?

+ 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. Replies: 19
    Last Post: 10-05-2012, 01:03 PM
  2. Is it possible to create a multi-step userform?
    By KDeMars in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2012, 03:26 PM
  3. Coping Data from multi sheets to a single sheet via criteria
    By airbus319uk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2010, 08:42 AM
  4. convert multi-sheets file to single-sheet files
    By yahata in forum Excel General
    Replies: 3
    Last Post: 04-22-2007, 06:54 AM
  5. Create a single sheet from many sheets
    By MS Office in forum Excel General
    Replies: 2
    Last Post: 09-07-2005, 04: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