Hi Lisa-

AFAIK there is no direct way to do so, although someone may offer up some
VBA procedure as a solution. What you might want to consider is setting up
another sheet as your print area and use simple formula links to read the
data in from the sheets where it is actually stored. Less desirable, but you
could also copy & paste from the other sheets to a single sheet and print
from it.

HTH |:)

"Lisa" wrote:

How can I print multiple worksheets from a workbook on one page?