Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to open file bypasses Auto_Open
I have the following code.
Workbooks.Open Filename:=vOpen, UpdateLinks:=3 But when I run this it does not process the macro Auto_Open. Why is this? I would like for code to run on the opening of the file regardless of how the user opened it. (ie. If they opened it using File / Open on the menu then yes, the Auto_Open would run. But I also want code to run even if they write their own macro to open it.) Thank you, Steven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
with a macro open a workbook without the Auto_Open running | Excel Programming | |||
Workbook Open bypasses Query Refresh | Excel Programming | |||
Macro runs upon wkbk open, but no Workbook_Open or Auto_Open Macro | Excel Programming | |||
Auto_Open only on initial file open | Excel Programming | |||
Auto_Open vs Open and call macro --priority question | Excel Programming |