Short-cut key

singcbl

Well-known Member
Joined
Feb 8, 2006
Messages
518
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?
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Can you explain in more detail what you mean by "it will not work"?

Is it not bringing up any macros?
Is it not allowing you to type in the shortcut?
Is it allowing you to type in the the shortcut, but just not taking?

What if you try Control-Shift-J instead of Control-J, does that seem to work?
 
Upvote 0
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.
 
Upvote 0
It works for me.
Alt + F8
Select macro
Press Options.
Enter "j" then press OK.

Press Ctr + j, the macro is running.
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,214,834
Messages
6,121,876
Members
449,056
Latest member
ruhulaminappu

We've detected that you are using an adblocker.

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.
Go back
Back
Top