Bruce,
What is value of ActiveWindow.SelectedSheets.Count ?
Unless there is some strange setting in the PDF print driver that limits
files to a certain size, I fail to see how you get 3 files from a single
print call.

NickHK

"Bruce" wrote in message
...
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