button print

akuccputsedut · #1 (**permalink**) 08-16-07, 23:01

hi..

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

thank's for help..

wattch · #2 (**permalink**) 08-27-07, 20:30

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

akuccputsedut · #3 (**permalink**) 08-29-07, 03:49

thank's you use pdf i mean acrobat pro or free PDF neo is printer name or what??