Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto_open()
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AUTO_OPEN | Excel Discussion (Misc queries) | |||
Auto_open | Excel Programming | |||
auto_open? | Excel Discussion (Misc queries) | |||
XLA auto_open | Excel Programming | |||
Beyond AUTO_OPEN | Excel Programming |