Actually, I was just able to combine 2 out of 3 sheets into one PDF just
now. I can't figure out why, when I hit file, then print in EXCEL, it
unselects more than one worksheet, and only sometimes, it seems. But I am
thinking that deleting sheets, even via macro, is dangerous, in that I might
resave the file under the same name accidentally. So, I am hoping you folks
can tell me some way to select any number of worksheets using the PDF
creator and have EXCEL accept all those sheets into a SINGLE PDF file,
which, by the way, I got from sourceforge.net.

Thanks!
Dean

"Dean" wrote in message
...
Last week, you folks clued me onto a wonderful, free PDF creator. Often,
I want to create a three page PDF from 3 of the worksheets in my EXCEL
template and it doesn't seem that I can highlight only those three sheets
together and make it happen. However, if I save a copy of my excel file
with all the other sheets deleted, after paste specialing values into the
three output sheets, of course - not a big deal to do via a macro - then
it seems quite able to print all the three sheets remaining in the revised
EXCEL file as a single PDF. In other words, it seems able to print all
the sheets into a single PDF, or just one sheet, but nothing in between.
Or am I wrong?

Regardless, I just did such a macro and it worked. The only problem is
that, I add additional sheets to some files and even change the names of
the other sheets (not the three in question). So, I need a macro
subroutine that will say, if the sheet name is anything other than Joe,
jack, and Harry, delete it. Can anyone help me with this?

Thanks much!
Dean