Second subroutine to run automatically
 

How do I get one subroutine to run automatically when another stops?
do not want the first to call the second. I am using th
Workbook_BeforePrint subroutine. When this closes the data will b
printed. THEN I want another subroutine to run automatically. Is thi
possible

--
Message posted from http://www.ExcelForum.com

Second subroutine to run automatically
 

You could us application.Ontime to run the second from the BeforePrint
event. Other than that, I don't think so.

See Chip Pearson's site on using Ontime

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy

"MatthewT " wrote in message
...
How do I get one subroutine to run automatically when another stops? I
do not want the first to call the second. I am using the
Workbook_BeforePrint subroutine. When this closes the data will be
printed. THEN I want another subroutine to run automatically. Is this
possible?


---
Message posted from http://www.ExcelForum.com/