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

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
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,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

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