Print all tabs to a pdf file

[JOSEPH WEBER]

I need a macro that will print all of the worksheets in an Excel workbook to
separate pdf files for each tab. I would also like to name the pdf file as
the name of the tab. How can I accomplish this?

 

[Ron de Bruin]

If 2007/2010 see
http://msdn.microsoft.com/en-us/library/ee834871(office.11).aspx

Or
http://www.rondebruin.nl/pdf.htm