Apr 10 2021 10:01 AM
I have a macro that works with the following basic structure:
__________________________
Sub Macro1()
Call jrMacro1
Call jrMacro2
Call jrMacro3
End Sub
_______________________
For some of the new macros that I created in the same workbook, for reasons that are entirely unclear to me, Excel has added the filename and module name in front of the Macro name.
So I need something that looks like
_________________________
Sub Macro2()
Call [filename]![module name].jrMacroA
Call [filename]![module name].jrMacroB
Call [filename]![module name].jrMacroC
End Sub
_____________________________________
What is the appropriate coding to achieve this?
Alternatively - and preferably - how do I remove the filename and module names from the leading naming convention for the macros themselves?
Thanks!
Apr 10 2021 12:32 PM
Make sure that you don't have macros of the same name in multiple modules.