Issue with macro names

[sparky2205]

I have a number of macros on a worksheet which I have added to the context menu. No problem, they all work fine.
I have now added 2 more macros which appear without issue on the context menu.
The problem: when I click on the macro name in the context menu it can't find the macro.
I've found the problem but I don't understand why it is happening.
My macro name is MoveSheet. When I look at the macros in my worksheet I can see that this macro is called CopySheet.CopySheet. Adding this macro name to the context menu setup, it works fine.
All my existing macros, which work fine, are called; CopySheet, DeleteSheet, RenameSheet etc.
I'm wondering why newly added macros, MoveSheet & ColourTab would be called MoveSheet.MoveSheet & ColourTab.ColourTab.

 

[Jeffrey Mahoney]

Are your module names the same as your SUB name? I've noticed problems when I have Module names, sheet names, code names, Sub names, or Function names the same as any of the others

 

[sparky2205]

Hi Jeffrey,
yes, the module and sub names are the same and I have seen issues with this myself previously so I usually avoid doing this.
These are older macros that I created a few years back before I was aware of that.
I did try changing the module names so that they differ from the sub names but it didn't appear to sort the issue.
However, I will revisit this as I now know that the macros work fine when assigned to a button. The difference being, of course, that I select the macro from a list rather then typing the name into the vbe to assign to the context menu.
I will look at this again in the morning and return here with an update.

 

[sparky2205]

Good morning Jeffrey,
this now works after changing the sub name to be different to the module name.
Interestingly it didn't work when I changed the module name.
Thanks for putting me back on the track I had wandered off.
Enjoy your weekend.