In the ThisWorbook module there is a before_print event that may be taught
to do this. UNtested
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Sheet12" Then
Sheets("sheet12").PrintOut 'Preview
Sheets("sheet9").PrintOut 'Preview
End If
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"fedude" wrote in message
...
Is it possible to intercept the print button with a routine that will
print
out the contents of 2 worksheets?
I'm trying to idiot-proof the printing out of the contents of two
worksheets
when the user either hits the print button or selects "print" from the
file
menu.