A macro name has suddenly add on the name of the workbook. Is this a potential problem?

[ILoveStMartin]

I do not have enough experience with macros to know if this is a potential problem or not.
Picture 1 - The file name in View Macros was not attached until I renamed the module it is in.
Note - I had already renamed 3 others and they did not change.
Problem or Potential Problem??
Thanks!!

Picture 2 Left here - went back to workbook. Saved it, closed and open. Now several with the file name attached -

And now getting "Can not run"

Hoping there is a wise and kind person out there with ability to help.

Note - I have copies of all macros so I could start over

[LJMetzger]

Hi,

I cannot duplicate your problem in Excel from Office 365, but it may be a problem in older versions of Excel.

There are several unwritten rules that I follow to avoid collisions like you are experiencing for two reasons:
a. There may be a collision problem which will probably be difficult to find.
b. To avoid confusion.

My personal rules include:
a. I always start Code Module Names with 'Mod' e.g. 'ModPrintSheet1'.
b. I never start routing names with the letters 'Mod'.
c. I never declare variable names with the same names as the routine (e.g. 'Sub PrintX()' will never have a variable named 'PrintX'.

Above all be consistent in your personal naming conventions.

NOTE: You probably have duplicate routine names if you ever see all items in the the Macro List of the form:
File Name!abc (All routines in the active file should not have the file name prepended)

I hope this helps.

Lewis

[Logit]

.
I wonder .. did you have more than one workbook open when performing those actions ?
Do both workbooks have macros named the same or similar ?

If so, you may have only been seeing the macros from both workbooks, renamed the wrong one and now since only the single workbook is open Excel can't locate the macro.