Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoRun
Hi,
I have a worksheet that loads automatically (Xlstart folder), but hidden. There is a few macros in it, but what I want to acheive is when I open a file I want a macro to execute, but I don't know where to put it. It doesn't work on the workbook_open sub, since this one starts only when the initial file loads. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoRun
If you want code to run when *any* workbook is opened, you need to use
application-level events, specifically the App_WorkbookOpen event (for opening existing workbooks) and/or the App_NewWorkbook event (when a new workbook is created). See http://www.cpearson.com/excel/AppEvent.aspx for details and example code. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Usen" wrote in message ... Hi, I have a worksheet that loads automatically (Xlstart folder), but hidden. There is a few macros in it, but what I want to acheive is when I open a file I want a macro to execute, but I don't know where to put it. It doesn't work on the workbook_open sub, since this one starts only when the initial file loads. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autorun | Excel Programming | |||
autorun a macro | Excel Programming | |||
Autorun.inf | Excel Programming | |||
Autorun a macro | Excel Programming | |||
Autorun Add-In | Excel Programming |