Excel 2010 - Save & Send a pdf - one tab? 1

[DJWheezyWeez]

I have an Excel 2010 spreadsheet that I'd like to export as a PDF. Currently, I use a PDF printer to save only one tab as a PDF but I was hoping there is a way to do this within Excel.

I click on File> Save & Send> Send as PDF and it saves the entire workbook into a single PDF. What I want to do is save just one tab. Is there a way to do this?

-DJWW

 

[SkipVought]

hi,

Once you get the process working, turn on your macro recorder and record.

1) right-click the sheet and COPY to NEW workbook.

2) print your PDF.

3) close without saving

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}