Results 1 to 3 of 3

Thread: button print

  1. #1
    Join Date
    Jun 2007
    Posts
    35

    Lightbulb Unanswered: button print

    hi..

    how to make button from control toolbox on worksheet function as a button print in excel..using vba

    thank's for help..
    **akuccputsedut**
    Intelligent is Me!!But a little confusing
    sometimes needs HELP!!

  2. #2
    Join Date
    Aug 2007
    Posts
    3
    Hi,

    Here is some code that I use in one of my proceedures:

    Code:
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
            "PDFill PDF Writer on Ne00:", Collate:=True
    It may just get you started.

    I'm using this to print to PDF but you could just insert your printer name.

    Regards
    Wattch

  3. #3
    Join Date
    Jun 2007
    Posts
    35

    ok

    thank's you use pdf i mean acrobat pro or free PDF neo is printer name or what??
    **akuccputsedut**
    Intelligent is Me!!But a little confusing
    sometimes needs HELP!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •