Print to PDF

[CFitz]

I've read over many of the Print to PDF threads and I seem to be having quite
the opposite problem. Most people can't get one pdf from several worksheets
but I can't seem to get one pdf per worksheet. What I want to accomplish is
to have the macro print out one pdf for each individual worksheet and name
the pdf the same name as the worksheet name. I'm sure it's easy I just can't
seem to get it to separate the worksheets.

Thanks!

 

[Jim Thomlinson]

You don't mention which program you are using to render your printout to
PDF... Adobe or ??? Here is a link to some code that I have used with
SourceForge...

http://www.excelguru.ca/node/21

 

[CFitz]

Sorry. I'm using Adobe PDF. I see that code is for PDFCreator and
unfortunately our IT department isn't going to be too friendly about
downloading outside software when we have other software available.