auto_open macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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"
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bypass Auto_Open 13
Unexpected file change 4
Auto_Open Macro 5
Auto_Open Code on Worksheet 2
Run Macro If Cell have "x" value 0
File opens another file runs macro and closes 2
auto_open() 5
Macro to open file bypasses Auto_Open 4

Back
Top