Record a macro that prints the entire workbook.
Use Tools-Customize, and place a new print button (that runs the macro) onto
the toolbar, and then remove the original print button icon. To record the
macro and info on the toolbar buttons, see this: http://www.theofficeexperts.com/officevba.htm#ExcelVBA
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
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.