PDA

View Full Version : Trigger macro when user opening any excel file



rajagopal
04-10-2012, 04:45 AM
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
04-10-2012, 04:57 AM
The user systems are not provided with personal.xls file to make the codes available centrally..

Jan Karel Pieterse
04-10-2012, 05:01 AM
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
04-10-2012, 05:03 AM
See:
www.jkp-ads.com/articles/distributemacro00.asp (http://www.jkp-ads.com/articles/distributemacro00.asp)
for an intro on making add-ins.