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
|