Hi,

I have recorded a macro to print my worksheets to a PDF buts its forcing me
to create multiple PDF's. There are 6 worksheets I am saving and the output
is prompting / saving 3 PDF files. The first has 1 worksheet, the second has
4 worksheets, and the last has 1.

I would 'ACTUALLY' like all worksheets to be saved as 1 PDF. What would be
causing the addin to prompt for spearate files here? I am using Excel 2000
SP3 and Acrobat v5.0.10

Bruce

Sub print_PDF()

Application.ActivePrinter = "Acrobat PDFWriter on LPT1:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Acrobat PDFWriter on LPT1:"

End Sub

Rgds,

Bruce