Macro name showing twice

[romandotcom]

Good Morning!
I am facing an unusual issue. Few of my macros name has been showing twice but macro is working properly. And “PERSONAL.XLSB!” is showing before every macro. I have attached a screenshot. But previously, names were okay and “PERSONAL.XLSB!” wasn’t there. Is there any way to change the double name into one? How can I remove the word “PERSONAL.XLSB!” from every macro?

Thank You !

Double Name.jpg

[LJMetzger]

Hi,

1. You probably have a Module with the name of 'RomanCensus' and a Sub/Function with the same name.

For example if you put the following Macro in Module1, you will see the same behavior.

Please Login or Register  to view this content.

It is a bad idea to have multiple items with the same name, even if they are modules, functions, types, or variables. It is even worse to use a name that is the same as an Excel KEYWORD.

To correct the problem, I would rename the module to 'ModRomanCensus'.

2. The PERSONAL.XLSB can not be removed. It is there to show that the macros are in your 'Personal Macro File' and not in the current file you are working on.

Lewis