'Ghost Macro' in list but not in editor

[Legacy 217727]

Hi all,
I've got a problem I couldn't find a solution for browsing numerous forums....

Macros are showing up in my Macro list (I mean the normal Macro dialog box); however, there's no trace of them in the VBA editor?!
Neither in the worksheets nor in any Modules, UserForms or else. I can't delete the Macros from the list or edit them.
I can trace some of the Macros back to a file that my workbook links into, but even changing this source book from .xlsm to .xlsx or deleting these sheets won't remove them?! (...I'm using Excel 2010)

Any idea what I'm fighting here and how best to attack?!
Thanks a lot!

 

[Legacy 217727]

How would I notice them? Do they show in the editor?

 

[RoryA]

No, but they appear as normal sheet tabs in the main UI - they may have been hidden though. You can run

Sub Macroshetcount()
msgbox activeworkbook.Excel4MacroSheets.Count
End Sub

to check.

 

[Legacy 217727]

Thanks! But both workbooks come back with a count of 0.


Is it possible that 2010 version can't cope with Macros from 1999?

 

[RoryA]

Unlikely. Can you give an example of a macro name?
Also, if you type a macro name into the name box on the left of the formula bar and press Enter, what happens?

 

[Legacy 217727]

The Macro Names are "ac", "Macro1", "Macro2", "Macro3".
Nothing happens when I type them into the name box...

One other hopefully helpful info is that each macro is listed exactly 10 times in the list, which seems to be dependent on the number of sheets that link into the original book (named Book2 above)...

 

[RoryA]

And the macros appear when you change the 'show macros in' dropdown in the macro dialog to a specific workbook?

 

[jimrward]

Are there any files in the addin folder with an xla extension

 

[Legacy 217727]

Yes, they behave like any macro assigned to a particular workbook in the macro list dropdown. They show if I hit Book1.xls, This Workbook as well All Open Workbooks...

 

[Legacy 217727]

My add-in folder is empty...

 

[Legacy 217727]

There's no way I can post my file? I've got a version stripped down of data still showing these macros...