auto_open()
 

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?

auto_open()
 

Ric,

See if the Workbook_Open Event is kicking off.

Regards,
Eddie
http://HelpExcel.com

auto_open()
 

Where would I check that? I can see the event from a program, but I don't
know how to use it when I am manually opening the workbook. Should it be
included in my macro as a sort of post-open debugging tool?

" wrote:

Ric,

See if the Workbook_Open Event is kicking off.

Regards,
Eddie
http://HelpExcel.com

auto_open()
 

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?

auto_open()
 

Sounds like you have put the code in ThisWorbook, instead of a normal code
module. Check this by right clicking on the Excel icon on the worksheet (or
next to the File menu if you maximise your workbooks), select View Code from
the menu, and paste the code.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
oups.com...
Ric,

See if the Workbook_Open Event is kicking off.

Regards,
Eddie
http://HelpExcel.com

auto_open()
 

Actually, this is my first macro. In the VB Editor from Excel, I don't see it
in the Project-VBAProject/Mocrosoft Excel Objects list. I added it as an
insert/module and that corrected my problem.

Thanks,
Rick

"Jim Rech" wrote:

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?