Thread: auto_open macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
travis travis is offline
external usenet poster
 
Posts: 43
Default 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