View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default BeforePrint event

I'd suggest that you write a print macro that goes something like this:

Sub MasterPrint
Activesheet.Printout
Workbooks("SubsidiaryBook1.xls").Open
Activesheet.Printout
ActiveWorkbook.Close False
Workbooks("SubsidiaryBook2.xls").Open
Activesheet.Printout
ActiveWorkbook.Close False
'etc.
End Sub

--
Jim Rech
Excel MVP
"EnglishTeacher" wrote in message
...
| How can I program a macro so that, when I print a workbook, it will
| automatically open and then print other documents to which I have linked?
|
| Thank you in advance.