PDF multiple sheets

[rexmann]

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

 

[Ron de Bruin]

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

 

[rexmann]

Thank you worked perfect

Cheers rexmann

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