View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MACRE0 MACRE0 is offline
external usenet poster
 
Posts: 1
Default A way to print to pdf every tab of Workbook?


I'm using Adobe PDF Professional and my simple macro
' ActiveWorkbook.PrintOut Copies:=1, Collate:=True "
which I'm 99% worked to print every tab in order of appearance to a pdf
file. Anyhow it doesn't work now for some reason and I was hoping
someone would have a suggestion or have a different way of attacking
the problem. The macro currently creates multiple PDF files for each
tab in order. I have way to many tabs to splice them together and too
many to list. Any help would be greatly appreciated,

Thanks.


--
MACRE0
------------------------------------------------------------------------
MACRE0's Profile: http://www.excelforum.com/member.php...o&userid=10848
View this thread: http://www.excelforum.com/showthread...hreadid=573973