Keyboard shortcuts on personal macros not working

[Lewzerrrr]

Hey,

Whenever I try to assign a keyboard shortcut to my personal macro's they never work.. it sticks to it when I go back in to change the key however when I try to perform it it doesn't work. Is something blocking this from my settings as non-personal macros work fine?

Thanks,

 

[MARK858]

What does the shortcut in the macro actually say and post your code?

 

[My Aswer Is This]

Yes that may be the problem. Let us know when you get it working. I do always make my Module Names and Macro Name a little different.

It's definitely not to do with the macro name as I have a few personal macros, none of which a keyboard shortcut work for.

Yes definitely in on my personal workbook. Thanks for trying though, I'll try to figure it out tomorrow.

Edit: think I've found the solution.. the module name is the same as the macro name resulting in a Personal.xlsb!modulenams.macroname, if I'm to change the module name it SHOULD fix it.

 

[Lewzerrrr]

Yes that may be the problem. Let us know when you get it working. I do always make my Module Names and Macro Name a little different.

It worked, the names were exactly the same.. e.g Module = WordWordWord.. Macro = WordWordWord so just changed the macro name to Word_Word_Word

 

[My Aswer Is This]

Glad you have things working. A new thing we learned Today. Take care.

It worked, the names were exactly the same.. e.g Module = WordWordWord.. Macro = WordWordWord so just changed the macro name to Word_Word_Word