Choosing an unused shortcut option when Ctrl is the only available modifier

mikecox39

Active Member
Joined
Mar 5, 2014
Messages
251
Office Version
  1. 365
Platform
  1. Windows
In the macro naming window, there is an option to create a shortcut to run the macro. But there is only one modifier key option (Ctrl) with an empty field for the character to complete the combination.


Why is there only one modifier option and how do I know that the character I choose isn't already part of a shortcut, like Ctrl-S?


Most programs use the Ctrl modifier in their shortcuts, which means there are a lot of Ctrl-[character] combinations that are already in use and can't be used, and, I believe, will overwrite the default.
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
All the Ctrl shortcuts are occupied.
You can use Ctrl + Shift + your alpha character. Just press the Shift key when you click into that tiny box and type in your letter. Just use a letter with Ctrl + Shift that is not F, L, O, P or U to avoid those built in shortcuts.
 
Upvote 0
You can create Ctrl+Shift shortcut keys by typing an upper-case letter using a Shift key.
 
Upvote 0
All the Ctrl shortcuts are occupied.
You can use Ctrl + Shift + your alpha character. Just press the Shift key when you click into that tiny box and type in your letter. Just use a letter with Ctrl + Shift that is not F, L, O, P or U to avoid those built in shortcuts.
Well, that's not very intuitive :laugh: Thanks, I would never have figured that out on my own /-:
 
Upvote 0
I was watching a macro tutorial last night and when the user tried to create a shortcut combination that was already assigned he got a popup that said that shortcuts combination was already being used and did he want to overwrite it. I didn't get that popup when I put a lower case "s" in that field. Shouldn't I have?
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,286
Members
452,631
Latest member
a_potato

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