Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto_open macro
I have a macro that runs everytime I open a new book after it is ran the
first time. I have to close Excel to open a new book without it running. What is causing this problem? I've tried changing the name of the macro without "auto_open". Sub Change() Application.OnWindow = "Restore_menus" Application.Windows("test2.xls").OnWindow = "Disable_menu" End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto_open macro
I am guessing Change the macro that was named Auto_Open.
In any event, I would say that Application.OnWindow sets an application level event. So anytime a window is activated (such as opening a new workbook) that Macro (Restore_Menus) will be run. If you want it workbook level, perhaps then Application.Windows("test2.xls").OnWindow = "Restore_menus" rather than Application.OnWindow = "Restore_menus" -- Regards, Tom Ogilvy "travis" wrote: I have a macro that runs everytime I open a new book after it is ran the first time. I have to close Excel to open a new book without it running. What is causing this problem? I've tried changing the name of the macro without "auto_open". Sub Change() Application.OnWindow = "Restore_menus" Application.Windows("test2.xls").OnWindow = "Disable_menu" End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto_open macro
Thank you, Tom.
Yes, at one point the macro was named "Auto_Open", I thought maybe that was the problem. It wasn't. This was very helpful. Travis "Tom Ogilvy" wrote: I am guessing Change the macro that was named Auto_Open. In any event, I would say that Application.OnWindow sets an application level event. So anytime a window is activated (such as opening a new workbook) that Macro (Restore_Menus) will be run. If you want it workbook level, perhaps then Application.Windows("test2.xls").OnWindow = "Restore_menus" rather than Application.OnWindow = "Restore_menus" -- Regards, Tom Ogilvy "travis" wrote: I have a macro that runs everytime I open a new book after it is ran the first time. I have to close Excel to open a new book without it running. What is causing this problem? I've tried changing the name of the macro without "auto_open". Sub Change() Application.OnWindow = "Restore_menus" Application.Windows("test2.xls").OnWindow = "Disable_menu" End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto_Open Macro | Excel Discussion (Misc queries) | |||
auto_open-macro | Excel Programming | |||
Disable event macro while Auto_open() run | Excel Programming | |||
Help with SaveAs Macro on Auto_Open | Excel Programming | |||
Auto_Open vs. macro | Excel Programming |