Take a look here for a description of a Workbook_Open event macro:

http://www.mvps.org/dmcritchie/excel/event.htm#wb_open

also,

http://cpearson.com/excel/events.htm

In article ,
pinguino2005
wrote:

I will like to know how to run a macro in Excel 97 when I open a a
workbook in excel.
The idea is that once i open a specific file in excel it automatically
runs a macro.
I need urgent help in this one.