Syntax to call Public Macro

I am Having trouble calling an macro that is not in the module that is calling it. I thought that all I had to do was label the Macro as Public instead of private, but it is not working. If I copy and Paste the Macro code into the module that is calling it, everything works just fine, but this is making it difficult to keep things organized. i know there has to be a way to do this, any help would be great!
I am currently just using the CALL command.

Please Login or Register  to view this content.

Thanks in advance for your help!

Is MyMacroModule2 in a normal module, or in a worksheet or ThisWorkbook module? If it's either of the last two, you would need to prefix it with the sheet name or ThisWorkbook as it is effectively a public method of those objects. I suspect it should simply be moved to a normal module though.

Do your module and sub have the same name? (they shouldn't really)

No problem. For the record, you could have used:

Please Login or Register  to view this content.

to work around it, but it's not good practice to use the same name for both a routine and its container, IMO.

Yes, though Call is optional, as is the module name if the macro name is unique within the project.