A few Macro questions

[ipbr21054]

Hi,
It’s time I cleaned up some of my Macro names from when I first started to record them.
Example.
You see a suggested macro name of say Macro12 so I just kept it.
I assigned the Macro to a button and works well.
Some time down the road I now want to clean up / rename these odd Macros.

Is there a way I can now find out which sheet / button it’s assigned too as how will I know, especially if it’s like Range A10.Select ???

Second question.
When I rename the Macro is it done by Alt & F11, right click on say Module 50 then enter the new name where Module 50 is currently typed ??

Or

Do I need to go to the top of page where I see Macro & Record Macro etc on the ribbon which then shows the box which has edit & step into etc ?

Once I successfully rename a Macro will the button in question still operate that Macro or will I need to assign it again ??

Thanks very much.

 

[alansidman]

With the macro open (Alt F11), click on View, Properties Window. In the Name line, type in the name you wish to have for the Macro. Save and Close

 

[ipbr21054]

Thanks very much.

 

[ipbr21054]

My question still applies.
If I have a Macro call gotocellM22 how can I find out which sheet it is on then which button is it assigned to.

Is the somecode that can advise me off all the Macro names, which sheet they are on & may the button namevetc ?

Thanks.

 

[Fluff]

Have a look here https://www.mrexcel.com/forum/excel-questions/480831-check-if-macro-assigned.html