Question to experts VBA
 

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

Question to experts VBA
 

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

--
Regards,
Tom Ogilvy
Mark wrote in message
...
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