View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Print to PDF with SHEET names

If you don't get many answers, you may want to include what software you're
using to create the .PDF files.

I would think that the solutions might vary between programs.



wrote:

Hello Everyone,

I am having a problem that is causing my head to nearly explode. We
need to figure out a way to print seperate worksheets from within a
workbook to PDF using the worksheet names. The problem we are running
into is that each time we go to print to PDF via a certain selected
sheet, we always save the file as the Workbook name. Is there any way
to have the PDF save as the worksheet name instead??? I have searched
through this forum and a few other for the last 2 hours and I can't
seem to locate anything.

Thanks for the help.


--

Dave Peterson