I am having problem trying to change the short-cut key. I have this macro that I originally have a short-cut key using Ctrl+j which I tried changing to Ctrl+m by going into the command Tool>Marco>Option but somehow but it will not work. Any reason?
What I did was to set the short-cut key in Option setting to Control j after pressing the Alt+F8 keys. The macro did not execute if I press the Control plus j keys.
After you go in and re-set it to CTRL-j, if you go back in to ALT-F8 then Options for that macro, does it look like your change "took" (i.e. does it actually display CTRL-j as your shortcut)?
Also, what is your Macro Security level set at? It isn't set to High, which would disable all macros, is it?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.