Runaway Macro!!!

Posted by Cory on June 25, 2001 1:38 PM

I've deleted every macro from my workbook and for one reason or another when I press Alt + F (for the File menu) the code for one of my buttons runs! I've looked everywhere for a relation to a macro using the f key, but can't find anything. What's going on?

Posted by Ivan F Moala on June 25, 2001 1:58 PM

Cory
Sounds like one of the commands for a command button that you have setup in one of the macros
has not been reset.
eg. if you had a macro that defined the action for
a commandbarbutton such as Copy;
Application.CommandBars.FindControl(ID:=19).OnAction = "NoGo"

Then this button will activate the macro NoGo
Closing excel down will NOT reset this, you have
to disable it by;
Application.CommandBars.FindControl(ID:=19).OnAction = ""

HTH

Ivan