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

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

Thank you worked perfect

Cheers rexmann

"Ron de Bruin" wrote:

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