Excel 2003: Macro to print areas in mulptiple worksheets

B

Balcott

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upgraded from Win 7 to Win 10. Publisher printing black. 1
Defining a print area in a macro 1
Wonky printout when I print entire workbook 0
How do you apply a print area to an entire workbook 1
printing multiple worksheets in a workbook 1
Userform to Select what worksheets to print 1
Save mulit-page two-sided document as a PDF 1
VBA code for "Save as PDF" 1

Top