You are not explaining the issue clearly. Excel can certainly create a PDF and print the file at essentially the same time. Even with a macro, though, one action must be done before the other. I cannot see what an e-book or the number of pages has to do with this. It doesn't matter whether you want to save to PDF or print - you'll still have to do your page setup and the more pages you have the longer that will take.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]