+ Reply to Thread
Results 1 to 15 of 15

Use checkboxes to define which sheets to convert to pdf

  1. 03-10-2014, 04:21 AM #1
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Use checkboxes to define which sheets to convert to pdf

    Hi

    need some help with a workbook i'm busy with, i need the user to be able to select checkboxes for which sheets to convert to pdf, every user will want to convert a different set of sheets in the workbook to pdf and it needs to covert all selected sheets to one pdf documents. I have added a example sheet with the code i have so far, but this example is for two sheets and the actual one has 15 sheets and the way i have done it with the if's the code is going to be weigh to long.....
    Anyone have any ideas?New Microsoft Excel Worksheet.xlsm
    Reply With QuoteRegister To Reply
  2. 03-10-2014, 05:39 AM #2
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Use checkboxes to define which sheets to convert to pdf

    Bump no response
    Reply With QuoteRegister To Reply
  3. 03-10-2014, 08:40 AM #3
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Use checkboxes to define which sheets to convert to pdf

    Bump no response
    Reply With QuoteRegister To Reply
  4. 03-10-2014, 01:33 PM #4
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Use checkboxes to define which sheets to convert to pdf

    Bump no response
    Reply With QuoteRegister To Reply
  5. 03-11-2014, 07:02 AM #5
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Use checkboxes to define which sheets to convert to pdf

    Bump no response
    Reply With QuoteRegister To Reply
  6. 03-12-2014, 02:12 AM #6
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Use checkboxes to define which sheets to convert to pdf

    Bump no response
    Reply With QuoteRegister To Reply
  7. 03-12-2014, 02:27 AM #7
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Use checkboxes to define which sheets to convert to pdf

    Hey there, hows my ol' stamping grounds? I grew up in PE, went to VPG and then VPH and then Tech RSA - where abouts are you in PE?

    Sorry you have had no response to this, I will try and push it for you (my VBA is really weak, sorry)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  8. 03-12-2014, 02:31 AM #8
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Use checkboxes to define which sheets to convert to pdf

    the world is incredibly small! never thought i'd meet an american PE boytjie here! i work in the Deal Party aArea, currently at the grindstone do you still have relatives etc here?
    Reply With QuoteRegister To Reply
  9. 03-12-2014, 02:34 AM #9
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Use checkboxes to define which sheets to convert to pdf

    I have a son in Port Alfred, I was there Feb last year for his wedding, been away from PE for 20+ years, could not believe how much Deal Party area has changed, got lost lol
    Reply With QuoteRegister To Reply
  10. 03-12-2014, 02:36 AM #10
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Use checkboxes to define which sheets to convert to pdf

    well on your next visit, you should pop by, have a drink ...... or six
    Reply With QuoteRegister To Reply
  11. 03-12-2014, 02:39 AM #11
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Use checkboxes to define which sheets to convert to pdf

    Sounds like a plan You need to try and hood up with a member named winnon, from the east rand
    Reply With QuoteRegister To Reply
  12. 03-12-2014, 07:10 AM #12
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Use checkboxes to define which sheets to convert to pdf

    Bump no response
    Reply With QuoteRegister To Reply
  13. 03-12-2014, 07:22 AM #13
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Use checkboxes to define which sheets to convert to pdf

    Hi,
    try this example, it's from this forum, I am sorry I do not remember the author!
    hope it helps you, at least for a start.
    Attached Files Attached Files
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-
    Reply With QuoteRegister To Reply
  14. 03-12-2014, 09:53 AM #14
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Use checkboxes to define which sheets to convert to pdf

    few small adjustments and this will work perfectly, thanks John
    thought it was a lost cause there for a second
    Reply With QuoteRegister To Reply
  15. 03-12-2014, 12:04 PM #15
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Use checkboxes to define which sheets to convert to pdf

    Hi man!

    You're welcome! Glad I could help you! The credits go to the author, I thank him/her too!
    bump,bump... lol
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 AM
  2. Convert this module to user define function (bold/colour substring)
    By rb123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2012, 08:18 PM
  3. I need to be able to define Sheets without knowing there name.
    By thedryden in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2006, 01:14 AM
  4. Connecting two checkboxes on different sheets
    By ph8 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2006, 06:10 PM
  5. [SOLVED] Define array of sheets by inputbox
    By Herman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2005, 11:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1