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?
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?