Excel -Use a keyboard shortcut to run a macro located in a Private Module
I want to run a macro "SubIReallyWant" by using a keyboard shortcut.
I can assign the shortcut programatically
That's also easy.
Changing the module to Option Private Module stops the shortcut :-/
Commenting 'Option Private Module makes the shortcut work again
Sure I could Do something like
'Shortcut "Ctrl +Shift + A"
Option Private Module
Do some stuff
Only this is kinda clumsy!
Looking for an eloquent solution?