View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JCO JCO is offline
external usenet poster
 
Posts: 54
Default Viewing my Macro

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