Viewing my Macro

  • Thread starter Thread starter JCO
  • Start date Start date
J

JCO

This is not that important but I'm curious. All of the sudden when I select
Macro, instead of showing my routine, the first one reads as shown below:

Error Report!Error Report!Error Report

Why is the name repeated then it should only be listed once.
Thanks
 
You description do not give a clue of what your code does etc. Is this from a error handle routine?

Anyhow, in general, the only time I experience douoble executions, is when the code start with a Worksheet_Change event and the sheet also has a Worksheet_SelectionChange, and you forget to set Application.EnableEvents = False.

/regards
 
No this is independent of the content of the code.
This is not being executed multiply times either. It's simply reads that
way when I select the Macro Button in Excel. Everything works great. It's
just the viewing of the first public sub that is displayed different than
the others.

If I select Run from the VBA section, the Sub-Routines are displayed okay
too. Only on the Excel page while selecting "Macro" do I get this Strange
Display. Functionality is okay.

That is why I said it's not a big deal, but has me curious.

Thanks

"tskogstrom" wrote in message

You description do not give a clue of what your code does etc. Is this from
a error handle routine?

Anyhow, in general, the only time I experience douoble executions, is when
the code start with a Worksheet_Change event and the sheet also has a
Worksheet_SelectionChange, and you forget to set Application.EnableEvents =
False.

/regards
 
Back
Top