View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jcy123@gmail.com is offline
external usenet poster
 
Posts: 3
Default Print to PDF with SHEET names

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.