Name of Macro in Project doesn't match the name of marco when I click the macro list from the tool bar

s_woodbury

New Member
Joined
Feb 26, 2014
Messages
27
I have macro's that Run other macros. I deleted one that I didn't think I needed anymore. Surprise!

I added it back in the project and named it exactly the same but the other macros no longer recognize it. I think I read before that when you rename a macro it for convience and that excel still refers to the Macro # (Macro2).

In the project its named "Forecast_EggCompareSelectRegion" but when I click on the Macro button on the tool bar it's 'WORKBOOK NAME.xlsm'!Forecast_EggCompareSelectRegion.Forecast_EggCompareSelectRegion'

If I click the second name in the macro box it takes me to the macro I want but the code is "Sub Forecast_EggCompareSelectRegion()

Really need some help....How can I fix this?
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,118,050
Messages
5,569,891
Members
412,298
Latest member
dietitiann
Top