Select the sheets first (grouped) then do the save

With code you can do this (see for example the example with sheet level names)
http://www.rondebruin.nl/pdf.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"rexmann" wrote in message ...
Hi

Not sure if this is possible and have spent the last hour looking for a
relevant tick box but is it possible to save multiple sheets to pdf. At the
moment it will only save one sheet at a time.

Any help greatly appreciated

Cheers Rexmann
PS using Excel 2007