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 |
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 |
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