I would like to print all the active worksheets in one PDF file. When I try
to print all the active worksheets, it will print a number of them in one PDF
file, then prompt me to name it, print another worksheet and prompt me, etc.
I don't understand why it will print a number (say 5 or 6) active worksheets
in one PDF file and then print only one (1) in the following. I print 40
active worksheets and it will create approximately 7 different PDF files.