Macor glitch?

[Guest]

I tried to run a macro to generate sales report. Somehow, the run time error 1004 message poped up saying "The macro 'Show_Toolbar" cannot be found. I debugged it and there is an unexpected code, Application. Run "Show_Toolbar", showing repeatly in a particular macro. When I deleted that code on the 17 pages VB code, the macro worked fine. It happens whenever I try to click a macro button. Ironically, the same macro runs gracefully on another computer.

Your suggestions will be appreciated.
-A

 

[Dave Peterson]

You click the button and the code starts. But part way through, it encounters a
"application.run "show_toolbar"" line that isn't there when you start????

I've never seen anything like this. There's no other macros running that modify
the code in this macro??

Maybe running Rob Bovey's codecleaner would help.

You can find it at:
http://www.appspro.com/

It exports your modules, removes the modules and then reimports them. The act
of reimporting them can remove a bunch of detritus that builds up through lots
of changes/recompiles.