Hi,

I have an Excel Workbook with c. 200 worksheets.

Is there a macro I can use that will create a PDF per worksheet, saved as per the name of the worksheet and saved onto my desktop?

Thanks
Eoghan