ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Viewing my Macro (https://www.excelbanter.com/excel-programming/449502-viewing-my-macro.html)

JCO

Viewing my Macro
 
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


tskogstrom[_2_]

Viewing my Macro
 
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

JCO

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



All times are GMT +1. The time now is 09:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com