It's a common problem with no real solution, I'm afraid. It's been discussed
recently here:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&c2coff=1&safe=off&threadm=uww
qV3UNEHA.796%40TK2MSFTNGP12.phx.gbl&rnum=2&prev=/groups%3Fq%3Dpdf%2Bseparate%2Bg
roup:microsoft.public.excel.printing%26num%3D20%26hl%3Den%26lr%3D%26ie%3DUTF-8%2
6group%3Dmicrosoft.public.excel.printing%26c2coff%3D1%26safe%3Doff%26scoring%3Dd
(or just use: http://tinyurl.com/3xmku )
Paul C,

Signature
> when i print multiple worksheets to pdf via acrobat distiller, the
> system always print each worksheet to different pdf file. why ?
>
> dennis
Try to look at this from Adobe, It solved the problem for
me: http://www.adobe.com/support/techdocs/9a4a.htm
Jesper
Jay Tidwell - 07 Jul 2004 20:57 GMT
Thanks. this is much better than clicking properties on each sheet.
> Try to look at this from Adobe, It solved the problem for
> me: http://www.adobe.com/support/techdocs/9a4a.htm
>
> Jesper