+ Reply to Thread
Results 1 to 13 of 13

Print Button to print UserForm for multi-sheet

  1. #1
    Registered User
    Join Date
    12-26-2006
    Posts
    54

    Print Button to print UserForm for multi-sheet

    Hello,

    I would like to have a button that prompts a UserForm to select which sheets/tabs to print from a workbook. This macro should identify the names of all the sheets in the file and display them in the userform with a checkbox next to each sheet, so the user can click which sheets he wants to print. Then there should be a Print button at the bottom.

    I found this link but I don't know how to make it work : http://spreadsheetpage.com/index.php...eets_to_print/

    Any help would be appreciated.

  2. #2
    Forum Contributor
    Join Date
    09-21-2009
    Location
    Belgium - Mechelen
    MS-Off Ver
    Office 365 - version 2310
    Posts
    278

    Re: Print Button to print UserForm for multi-sheet

    Hi,
    See this thread in this forum.
    It should be exactly what you need.

    http://www.excelforum.com/excel-prog...-printing.html

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Print Button to print UserForm for multi-sheet

    Quote Originally Posted by MarMo View Post
    Hi,
    See this thread in this forum.
    It should be exactly what you need.

    http://www.excelforum.com/excel-prog...-printing.html

    I think that MarMo means post #4
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    12-26-2006
    Posts
    54

    Re: Print Button to print UserForm for multi-sheet

    Quote Originally Posted by royUK View Post
    I think that MarMo means post #4
    Yes, this is fine and working great. But when I click the print button after selecting the sheet, it is directly printing to the default printer. Is there a way to open the printer selection rather than printing to the Default Printer?

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Print Button to print UserForm for multi-sheet

    Something like
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    12-26-2006
    Posts
    54

    Re: Print Button to print UserForm for multi-sheet

    Quote Originally Posted by royUK View Post
    Something like
    Please Login or Register  to view this content.
    Thanks for this codes, can you please tell me where should I place them?

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Print Button to print UserForm for multi-sheet

    Add it to the print button on the form
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    12-26-2006
    Posts
    54

    Re: Print Button to print UserForm for multi-sheet

    Quote Originally Posted by royUK View Post
    Add it to the print button on the form
    Please Login or Register  to view this content.
    Thanks a lot royUK, it works fine.
    Normaly I print to PDF files, now every sheet is saved to PDF as a file, but I need all sheet to be saved as a PDF. Is there a way for this?

  9. #9
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Print Button to print UserForm for multi-sheet

    Which PDF writer are you using?

  10. #10
    Registered User
    Join Date
    12-26-2006
    Posts
    54

    Re: Print Button to print UserForm for multi-sheet

    Quote Originally Posted by royUK View Post
    Which PDF writer are you using?
    I am using http://www.bullzip.com/products/pdf/info.php

  11. #11
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Print Button to print UserForm for multi-sheet

    I'm just working on an addin to automate Bullzip, I'm trying to finish it this weekend. So far you can select sheets to use,print all sheets or a specific sheet.

  12. #12
    Registered User
    Join Date
    12-26-2006
    Posts
    54

    Re: Print Button to print UserForm for multi-sheet

    Quote Originally Posted by royUK View Post
    I'm just working on an addin to automate Bullzip, I'm trying to finish it this weekend. So far you can select sheets to use,print all sheets or a specific sheet.
    Hi royUK, any success in this work?

  13. #13
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Print Button to print UserForm for multi-sheet

    I have it almost completed

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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