Macro keyboard shortcuts not working

[JasonNH]

Hello Forum,

I have a problem with shortcuts to run macros. Only new keys are working. For example if I assign Ctrl+K it works but if I remove that setting or even delete the whole macro I cannot assign Ctrl+K again in a new macro. Assigning another combination still works if it was never assigned before.

Where are these settings saved in Excel? Can I delete all or is there a way to fix this. I'm running out of keys.

Thanks for answers.

 

[JasonNH]

Found a solution, method 1 worked for me.

Macro keyboard shortcut doesn't work

I have a couple of macros in my PERSONAL.XLSB file. Both are assigned a keyboard shortcut, but only one works with the shortcut. It worked briefly, but not anymore. This works: Sub ShowAllCTRLEND() ' ' Keyboard Shortcut: Ctrl+q ' If ActiveSheet.FilterMode = True Then...

www.mrexcel.com