Trigger macro when user opening any excel file

[rajagopal]

Hi,

My users are working in excel workbooks. I want a custom message box to be displayed before they close any excel workbook. The excel file opened by the user will not have any macro codes.

How can i get this done?

[rajagopal]

The user systems are not provided with personal.xls file to make the codes available centrally..

[Jan Karel Pieterse]

You would need an addin that utilises a class module to capture application events. See:
http://www.cpearson.com/Excel/AppEvent.aspx

[Jan Karel Pieterse]

See:
www.jkp-ads.com/articles/distributemacro00.asp
for an intro on making add-ins.