Local Function referenced with *.xlm! prefix

[pizzaboy]

Under Macros, functions from one of my modules has the workbook and module name prefixed to it. Wouldn't be much of a concern, but it won't let me assign a shortcut key to it as a result.

How do I get the macros to name the functions as initially set?


Any help would be greatly appreciated.

Cheers

 

[hotabae]

I usually run into issues like that when there are duplicates floating around.

Make sure the name of the Sub isn't replicated anywhere else within your modules.

 

[pizzaboy]

No duplicates hotabae

I was originally copying modules over from another project which may have caused the initial conflict, however they are pointing to the right module functions (the prefix points to the right place!).

 

[hotabae]

The reason Excel is adding that prefix is because it needs extra clarification as to Which version of the macro you wish to use.

I was originally copying modules over from another project

If you have the original project open still, it would treat the new ones as "duplicates" and need to specify the ones from THIS project.​

-Another Cause can be having a duplicate macro/sub that exists in your "Personal" workbook
​

If you are running a macro via Sheet1, but the code is stored in sheet2's code, it would do something like that.

If you have a macro that shares the same name as a module or userForm, it would cause this issue.

If the source of your macro is a module in another workbook, it would appear like this.​

Outside of these cases, there may be other causes, but I'm not familiar enough with them to denote them at this time.

Hope this helps!

 

[pizzaboy]

Thanks hotabae

I've closed all other workbooks. No more conflicting names (workbooks/sheets or module/functions), unfortunately the issue still stands - can't assign a shortcut to a macro which has a hard referenced assignment...