Question to experts VBA

[Mark]

Hi,
Have been possible writting in VBA programme (only in
personal.xls), which for every opened or created workbook
add text to headline of printout?
Question concern MsExcel, but I wonder, if it possible to
do for MS Word and another application MSOffice also.
Thanks for any help.
Regards
Mark

 

[Tom Ogilvy]

In Excel, you could put it in the BeforePrint event using application level
events.

See Chip Pearson's page on Application.Level Events:

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

You could instantiate them in your personal.xls