you would use the workbook_open event. As long as macros are not disabled
either by the security setting or manually by the user, it would run on
opening.

http://www.cpearson.com/excel/events.htm
describes the various events available to you.

--
Regards,
Tom Ogilvy


"Daniel" wrote:

How to program VB so that when open the Excel work book it run the macro
automatically without hit tool/ macro/run
Thnks
Daniel