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.
|