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,

 

[My Aswer Is This]

Explain how your assigning the keyboard shortcut to the macros in your personal workbook.
And give me a example of a keyboard shortcut your using.

Always use a lower case letter like r or p
Not R or P When assigning the shortcut key.

But to use the keyboard shortcut you can use R or P

 

[Lewzerrrr]

Explain how your assigning the keyboard shortcut to the macros in your personal workbook.
And give me a example of a keyboard shortcut your using.

Always use a lower case letter like r or p
Not R or P When assigning the shortcut key.

But to use the keyboard shortcut you can use R or P

I open up a new workbook, Book1 - Excel > Developer > Macros > Options... > Shortcut Key

I tried Ctrl Shift R.. Ctrl Shift D.. Ctrl Shift S..

Tried to use Ctrl A as I don't use region but it doesn't override it.

 

[My Aswer Is This]

Like I mentioned earlier:

Try Ctrl a

Use lower case a

But when you want to run the script you can use Ctrl A

Using lower case overrides Excel default for Ctr A

 

[Lewzerrrr]

Like I mentioned earlier:

Try Ctrl a

Use lower case a

But when you want to run the script you can use Ctrl A

Using lower case overrides Excel default for Ctr A

Yeah I've tried that but doesn't seem to work.

When I go back into the keyboard shortcut it comes up that it's ctrl + a but just doesn't seem to work, it still selects the region.

 

[My Aswer Is This]

Are you using a "Apple Computer" ? What version of Excel?

Yeah I've tried that but doesn't seem to work.

When I go back into the keyboard shortcut it comes up that it's ctrl + a but just doesn't seem to work, it still selects the region.

 

[My Aswer Is This]

And when you go into the Macro dialog box where you see:

Macros In: Your choosing "Personal"

 

[Lewzerrrr]

And when you go into the Macro dialog box where you see:

Macros In: Your choosing "Personal"

Excel 2016 on a Samsung computer, again this doesn't affect any non-personal macros.. just personal that it's not working.

Correct

 

[My Aswer Is This]

Be sure you do not have the same macro in the Normal Workbook and also in the Personal Workbook with the same name.

I'm not familiar with Excel 2016. I'm using 2013. Not sure if any changes.
And your sure the Macro is in the Personal Workbook.

Other then that I'm not sure why your shortcut keys would not work.

 

[Lewzerrrr]

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.