Cleaning up "Macro Name" screen

[jlax34]

I have an odd one here that I haven't been able to figure out. Doesn't affect any functionality, but simply drives me nuts! Anyone have any ideas??

When I click the view Macros button from a normal workbook, I get my normal list of Macro which is fine except that some of them are listed with the Macro name twice (examples below). First 2 are fine, next 2 are duplicated.


PERSONAL.xlsb!CopyToNewSheetsByGroup2
PERSONAL.xlsb!CopyToNewSheetsbyGroup2New
PERSONAL.xlsb!Deadstock.Deadstock
PERSONAL.xlsb!Inv_View.Inv_View


Even weirder, If I have the actual macro file (Personal.xlsb) open and view macros, in addition to some with duplicate names, it seems to treat them as if they are in an entirely different sheet (with the same name)...which they are not. Some of these have been imported from old Macro files on other computers into new ones (like the first 2 below), while other have been created on this computer which seems to account for most of the differences. However, I would assume I could go in and adjust the properties/names somewhere but I can't figure out where. Everytime I think I have found a place to update, I look at the normal and abnormal macros, and they are listed in the same format so I don't see what I can change. Any ideas?

CopyToNewSheetsByGroup2
CopyToNewSheetsbyGroup2New
PERSONAL.xlsb!Deadstock.Deadstock
PERSONAL.xlsb!Inv_View.Inv_View

 

[RoryA]

Don't name the module the same as the macro.