Excel macro keyboard shortcuts not working

Question

I have read all of the "answers" to my question, but none apply to my problem, so:

I have several Excel 2013 workbooks with macros that work with the buttons I have created; i.e. SAVE, Print, etc. I have tried to create keyboard shortcuts to use from anywhere in the worksheet by coping to macros/ selecting the target macro such as save/ clicking on Options and using C+S(the tab button) and a keyboard letter such as M , but none seem to work. I am able to use the standards such as C+S to save, C+P to print,etc.

Answer 1

Hi,

There can be several reasons why your Excel macro keyboard shortcuts may not work. Here are some steps that you can try:

1. Make sure the macro is assigned to the correct keyboard shortcut: Go to the Developer tab, click on Macros, select the macro you want to assign a keyboard shortcut to, click on Options, and verify that the correct keyboard shortcut is listed. If not, enter the desired keyboard shortcut and click OK.
2. Check for macro security settings: If the macro is not digitally signed, Excel may prevent it from running or from being assigned a keyboard shortcut. Go to the File tab, click on Options, select Trust Center, click on Trust Center Settings, select Macro Settings, and make sure that "Enable all macros" is selected.
3. Check for macro code errors: If your macro has an error in the code, it may prevent it from running or from being assigned a keyboard shortcut. Open the Visual Basic Editor (Developer tab > Visual Basic), select the macro, and check for any errors or warnings.
4. Check for corruption: It may be possible that your macros are corrupted. In that case, you may need to check and repair them. You can try using "Open and Repair" and see if it fixes the issue.

Hopefully, one of these methods work out for you.

Best Regards.

Answer 2

I found out that if you have the same name for the module and the Sub then shortcuts won't work. I added a number to the Sub name and the shortcut started working again. You could also see it when opening the macro window with all macros, if they have the same name it will include the name of the excel file otherwise it will only contain the Sub name.

Answer 3

Hi @Ken Smith ,

Firstly make sure you have enabled macros in all workbooks via Trust Center.

1. Click the File tab, and then click Options at the very bottom of the left bar.
2. On the left-side pane, select Trust Center, and then click Trust Center Settings… .
3. In the Trust Center dialog box, click Macro Settings on the left, select Enable all macros and click OK.
   Click the File tab, and then click Options at the very bottom of the left bar.

If the macro is still not working, have a try to the troubleshooting steps in this article: How to Troubleshoot Macros in Excel Not Working. Generally, it works in common scenarios. Feel free to let me know if this helps.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

Nope, all of the above does not solve the problem. However, checking my other workbooks, the assigned shortcuts do work; just this particular workbook not working. ???

Answer 5

nope: does not solve the problem. shortcuts in my other workbooks do work, however.