When I tried to run a macro from a button today, it said something like "name
not recognized". I noticed my macro name had changed from:

"MatchUnits"
to
"WorkbookName.xls!MatchUnits.MatchUnits"

Does anyone know why this happened and what I can do to fix it?

I am an infrequent and fairly inexperienced macro "programmer".

Thank you!!

That happens when you name the module the same as one of your macros. Try
changing the name of your module to something else, like modMatchUnits.


"Cornelia" wrote:

When I tried to run a macro from a button today, it said something like "name
not recognized". I noticed my macro name had changed from:

"MatchUnits"
to
"WorkbookName.xls!MatchUnits.MatchUnits"

Does anyone know why this happened and what I can do to fix it?

I am an infrequent and fairly inexperienced macro "programmer".

Thank you!!

One other thing, if it still doesn't run, try reassigning the macro to the
button. Sometimes when copying/pasting and moving things around, the buttons
can get linked to an old workbook, and not your new workbook.

"Cornelia" wrote:

When I tried to run a macro from a button today, it said something like "name
not recognized". I noticed my macro name had changed from:

"MatchUnits"
to
"WorkbookName.xls!MatchUnits.MatchUnits"

Does anyone know why this happened and what I can do to fix it?

I am an infrequent and fairly inexperienced macro "programmer".

Thank you!!