auto_open a macro in every file opening

S

SPIRONIK

Hello,
I am new to VBA and I would like to ask what should I do, in order to
present a msgbox -in a shared xls file-, evey time a user opens it.
thanks a lot
 
J

Jim Rech

Two kinds of procedures run automatically when an Excel workbook is opened
if macros are enabled: A sub named Auto_Open put in a standard module and
the WorkBook_Open event hander sub in the ThisWorkbook module. This article
discusses the second method:

http://support.microsoft.com/default.aspx?scid=kb;en-us;265113

This technique works for Excel 97 and all later versions.

--
Jim Rech
Excel MVP
|
| Hello,
| I am new to VBA and I would like to ask what should I do, in order to
| present a msgbox -in a shared xls file-, evey time a user opens it.
| thanks a lot
|
|
| --
| SPIRONIK
| ------------------------------------------------------------------------
| SPIRONIK's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=12430
| View this thread: http://www.excelforum.com/showthread.php?threadid=277318
|
 
Top