In a nut shell, I assigned a keyboard shortcut to run a particular macro and I started to get strange results all of a sudden whilst running it. I therefore posted a help thread headed “File SaveAs weird behaviour yesterday (see following link to get more information). File SaveAs weird behaviour.
I noticed, that rather than using the keyboard shortcut, if I ran the macro by selecting ALT+F8 and running it from there, then I didn't get any strange results and the macro ran as expected.
So I repeated the test by running from Keyboard Shortcut, and again strange results, ran by using ALT+F8, and no problems. I can recreate this behaviour at will.
Did a search on Google using “macro keyboard shortcut not working” and it displayed results that people had reported.
One of the things I read was that if you remove the shortcut key, rename the macro, assign a new key then it should work.
Alas it didn’t work, and therefore I am using the ALT+F8 option.
I hope that the above helps people if they encounter strange results/behaviours. This drove me loopy lef me tearing my hair out and questioning my sanity.
I noticed, that rather than using the keyboard shortcut, if I ran the macro by selecting ALT+F8 and running it from there, then I didn't get any strange results and the macro ran as expected.
So I repeated the test by running from Keyboard Shortcut, and again strange results, ran by using ALT+F8, and no problems. I can recreate this behaviour at will.
Did a search on Google using “macro keyboard shortcut not working” and it displayed results that people had reported.
One of the things I read was that if you remove the shortcut key, rename the macro, assign a new key then it should work.
Alas it didn’t work, and therefore I am using the ALT+F8 option.
I hope that the above helps people if they encounter strange results/behaviours. This drove me loopy lef me tearing my hair out and questioning my sanity.