Personal Macro Workbook Keyboard Shortcuts Not Working

[Barren_Wuffett]

I recently changed laptops. And now when I try and record macros on my personal macro workbook and assign a keyboard shortcut, the keyboard shortcuts don't work. However, if I open up the code/VBA and click run, it runs the macro just fine. Anyone know how to fix this?

 

[Joe4]

I think you may need to re-assign them on your new computer.

 

[Barren_Wuffett]

I fully re-recorded and reassigned them. Keyboard shortcuts still not working.

 

[Joe4]

What is the exact keyboard shortcut you are trying to assign?
After you attempt to reassign the keyboard shortcuts, if you go to the Macros menu, select View Macros, select the macro you just tried to assign and click on the Options button, does it show it being assigned?

 

[Barren_Wuffett]

I've tried multiple. ctrl + shift + C, D, R, H, etc.

Yes it shows as assigned to that key in the Macro Options

 

[Joe4]

I did a search for people with the same problem, and came up with a few possibilities.
Have a look at these:

https://answers.microsoft.com/en-us/msoffice/forum/all/keyboard-shortcuts-for-macros-stopped-working/68863811-605e-495d-8e49-ab5480c8573e

Keyboard Shortcuts Not Working for Macros

I'm using Excel 2010 with Windows 7. I'm new to macros. I've been recording macros and trying to assigning a keyboard shortcut in the Record Macro window but, they don't seem to stick. The macro keyboard shortcuts work with the first use but, don't work if I close Excel and try to use them...

www.mrexcel.com

Code runs using F8 or F5 but not using the keyboard shorcuts?

Hi there, I've written a macro which is meant to copy the contents of the current row then open another workbook from a standard location, locate the same line and paste in the copied information. The macro is then meant to save and close the workbook it opened with the changes. The 'VesselID'...

www.mrexcel.com

Hopefully one of those might help shed some light on it.

 

[Barren_Wuffett]

None of the solutions therein were applicable.

 

[Joe4]

Try creating a brand new workbook, and creating a very simple VBA procedure, and try applying a keyboard shortcut to it.
Does it work?

If it does, then that suggests there may be an issue with the particular workbook (maybe some corruption?).

If it does NOT work, then assuming that you are applying the shortcuts correctly, that would suggest there may be a problem with the installation of Excel on that computer.
Make sure that you have applied ALL updates and fixes, so you are current.