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

 

[RoryA]

Do you mean keyboard shortcuts?

 

[ooptennoort]

Do you mean keyboard shortcuts?

Yes (sorry, can't edit anymore).

 

[RoryA]

So what exactly is happening when you use the shortcuts?

 

[ooptennoort]

So what exactly is happening when you use the shortcuts?

Default excel keyboard shortcut settings are back (CTRL+d is filling down again instead of running macro)

 

[RoryA]

Do the macros appear in the macros dialog?

 

[ooptennoort]

Some of my other keyboard shortcuts do still work. But not always They sometimes stop too and then I change the macro 'name' after Sub or the properties 'name' and either sometimes works. Just now it doesn't. Somstimes closing all instances of excel (sand saving all) helps. But not always. Once it helped to restore my backedup PERSONAL.XLSB, but not this time... It seems so random; I can't see a logical pattern. I haven't changed anything to do with Add-Ins (that I'm aware of...). I've had a lot of "Send frown" crashes with power Query lately, but not today (and not sure if related). I need to learn more about the inner workings of macro's/excel, step by step.

 

[ooptennoort]

Do the macros appear in the macros dialog?

Yep. This time they do (posted another thread about this; solved by restoring a backup of my personal.xlsb).
I have run an office repair (install) in the past, which didn't make much of a difference (as far as I could tell...)

 

[ooptennoort]

If this is true (short of time), this might have to do with seemingly randomness (will test soon... now deadline... always trouble at deadline time):

'One thing I did learn: anytime you make any changes to macro code/a module, it seems to delete/invalidate the keyboard shortcut you had previously assigned. And then you have to use ALT + F8 to assign it again.'

From: Redirecting

HOWEVER, re-assigning the same shortcut does not make it work again.

 

[RoryA]

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