I have 4 Macros saved to my Personal workbook. 2 of them will not work using the assigned keyboard shortcut but will run from the Macro dialogue box. I created these probably over a year ago and have used regularly since then without issue.
I tried selecting options to change the shortcut key.
I tried deleting the macro and redoing.
I've searched and am running out of ideas.
I don't know if this is relevant, but when I select the dialogue box, the 2 having issues have a strange naming convention. Screengrab below - the 2 showing Personal.xlsb! are the 2 with issues.
Any help or suggestions would be much appreciated!
I tried selecting options to change the shortcut key.
I tried deleting the macro and redoing.
I've searched and am running out of ideas.
I don't know if this is relevant, but when I select the dialogue box, the 2 having issues have a strange naming convention. Screengrab below - the 2 showing Personal.xlsb! are the 2 with issues.
Any help or suggestions would be much appreciated!