Change macro Sub name vs Properties name?

[ooptennoort]

I was advised (internet somewhere) to change the name of my macro's to solve my issue that, somehow, the shortcuts assigned to my (public) macro's in my PERSONAL.XLSB stopped working.

Q1) Should I change the words after Sub or change the name in the properties window?

Q2) What effects do changing either have? Can anyone advise a best practice dealing with this 'duplicity' (for lack of a better word)?

Q3) Is there the a better way of solving my issue that, somehow, the shortcuts assigned to my (public) macro's in my PERSONAL.XLSB stopped working (this should be another thread, I realise)?

 

[ooptennoort]

If you select File - Options - AddIns, does your workbook show in the list of disabled items?

No, none.

Don't know if this makes sense but it seems to usually (always?) happen with macro's that have 'a dot' in the Alt+F8 pane... see blue:

This probably has something to do with my trying to rename macro's, but since different kinds of renaming of macro's seem to go around I don't know what I'm doing (not a VBA expert).

 

[RoryA]

That happens because you named the module and the macro the same. That is generally not a good idea.

 

[ooptennoort]

That happens because you named the module and the macro the same. That is generally not a good idea.

Ah, so here I see difference between the two (at least verbally). Which brings me to the start, i.e. to Q1 & Q2: which is best practice, changing only the module (through properties window, right?) or only the macro (through changing the words after 'Sub', right?) and how do I 'live' with the name discrepancy between the two? How do you experts go about this?

 

[RoryA]

All my modules have a prefix assigned to the name. I have no idea what you mean by "how do I live with the name discrepancy"? They should have different names.

 

[ooptennoort]

All my modules have a prefix assigned to the name. I have no idea what you mean by "how do I live with the name discrepancy"? They should have different names.

It is starting to dawn on me. I'm sorry. I now realise, which seems silly I now realise; I tried and now see I one can copy more than one macro in one module and a line appears. So this allows Grouping/Hierarchy of sorts. Thank you. Had not realised this.