You didn't put it in the ThisWorkbook module by any chance? It should be in
a standard module (Insert, Module).

--
Jim
"rick_mc" wrote in message
...
I wrote a macro with the sub Auto_Open(). This macro is supposed to run
automatically when I open excel workbook (double-click existing workbook
file
to open), but it is not running? I can run it after I open the book, which
shows the macro works w/o errors. Can someone point me to docs or offer a
solution?