I have a print area in each of 5 different worksheets of the same file. Would
like to create a macro to print all ranges simultaneously (all into one PDF
file, or as a complete report to a printer).
The file is also distributed to our customers for their use, and I want to
allow them the same print function (hence a macro button is handy).
Any suggestions?

Thanks
Bob