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

Excel 2003 - How to print areas in separate sheets to 1 pdf file 1
Need to print a workbook but worksheets have diff print areas 1
Excel 2007 Multiple Print Areas 0
A macro code to print multiple sheets in different w.books 3
print all worksheets of Excel file to one pdf file 3
Setting print areas 5
Print worksheets in external workbooks 2
Print mult worksheets to Adobe 2

Top