Macro Short Cut Keys (Ctrl Shift a-z) Not Working One-by-One

[TRMMolloy]

I have about 15 macro shortcut keys in Personal.xlsb to do simple tasks, but they are slowly but surely starting to be disabled. Last week, Ctrl-Shift-d (change pivot table detail table to range) stopped working; yesterday, Ctrl-Shift-z (change format of highlighted cells to "#,##0") stopped working.

I tried all of the suggestions in the various threads on MrExcel and elsewhere to no avail. So I ran a test (TLDR: demonstrating each step I took to solve problem):
1. Closed Excel, backed up personal.xlsb, erased it from the Excel Startup directory.
2. Rebooted.
3. Opened Excel, confirmed that there were no macros.
4. Recorded a new macro, setting the shortcut key to Ctrl Shift z (i.e. Shift z in the option box)
5. Created a simple macro:

Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+Shift+Z
'
Range("E4").Select
ActiveCell.FormulaR1C1 = "Hi there .. Isn't this fun"
Range("E6").Select
ActiveCell.FormulaR1C1 = "Yes"
Range("E7").Select
End Sub

6. Confirmed the macro works by using Macro window Run command on "PERSONAL.XLSB!Macro1"
7. Select blank sheet
8. Select Ctrl Shift z .... Nothing.

I ran through the usual sequence of confirming something was wrong:
- deleted shift z in the Macro Options window
- closed Excel (saving Personal Macro Workbook)
- opened Excel, confirmed no shortcut was assigned to Macro1 in Macro Options window
- closed Excel
- opened Excel
- assigned Ctrl Shift z to Macro1 in Macro Options window
- closed Macro window.
- Selected Ctrl Shift z .... Nothing.
- Confirmed that Macro1 works by running Personal.xlsb!Macro1 from the Macro window.
- Closed Excel (saving Personal Macro Workbook)
- Opened Excel
- Confirmed Ctrl Shift z assigned to Macro1 in Macro Options window
- Closed Macro window
- Selected Ctrl Shift z .... Nothing

What about a different letter?
- opened Macro Options window
- assigned Ctrl Shift s to Macro1
- closed Macro window
- Select Ctrl Shift s .... Macro Works!

- opened Macro Options window
- assigned Ctrl Shift z to Macro1
- closed Macro window
- Selected Ctrl Shift z .... Nothing

- I confirmed again that Ctrl Shift s runs the macro, Ctrl Shift z will not.

So something is preventing Ctrl Shift z from working (Ctrl Shift d, too), I just don't know where to look. Registry key, maybe?

Settings, etc:
Trust Center Macro Security Setting: Enable All Macros
Windows 10
Office 2016
Excel 64-bit

Thank you.

 

[bobsan42]

I cannot confirm it now, but are you sure shortcut keys run a macro when the workbook containing it is not the current/active one?
Or if it is just a few letters that don't work - have you assigned them to other macros? Or have you installed something else that may have hijacked them?

 

[bobsan42]

Maybe have a look at this post:

Where are user keyboard shortcuts stored

I tried searching this website for "shortcuts file" or "shortcuts storage" and found nothing. When writing VBA, I would like to specify a shortcut. I've noticed on recorded macros the line that Excel puts in that is just a comment line acknowledging the shortcut exists. But where is this...

www.mrexcel.com

 

[TRMMolloy]

This and the other macros are in my Personal Macro Workbook (personal.xlsb), and those macros are always active.

As I explained in the original post following "What about a different letter?", I can substitute "Shift s" for "Shift z" in the Macro Option window and the macro runs when Ctrl-Shift-s is selected. Change it back to "Shift z", and nothing happens when Ctrl-Shift-z is selected.

re: ".. if it is just a few letters that don't work - have you assigned them to other macros?" No, I have not assigned them to other macros.

re: "... have you installed something else that may have hijacked them?" I have not. Computer installations are controlled by corporate IT via the company VPN, and stuff gets installed all of the time. Microsoft issues a patch, they install it. I cannot recall if something was installed prior to Ctrl-Shift-d or Ctrl-Shift-z getting disabled. It is entirely possible something is hijacking the shortcut key sequences, but our IT people would not know where to look to determine it.

It is up to me to figure it out and petition them to change it on my machine.

 

[bobsan42]

Check number 2 here:

What does the Ctrl + Shift + Z keyboard shortcut?

Are you curious what Ctrl + Shift + Z does in 238 programs? Here is the list.

defkey.com

 

[TRMMolloy]

Maybe have a look at this post:

Where are user keyboard shortcuts stored

I tried searching this website for "shortcuts file" or "shortcuts storage" and found nothing. When writing VBA, I would like to specify a shortcut. I've noticed on recorded macros the line that Excel puts in that is just a comment line acknowledging the shortcut exists. But where is this...

www.mrexcel.com

Thanks. Unfortunately, some of the links either generate an error, or my company internet access will not allow access.

Unfortunately #2: what none of the replies in that thread could provide insight on why Excel will not allow a new macro on a clean slate (i.e. no macros in Personal.XLSB) to be assigned to Ctrl-shift-z, while it will allow the same macro to be assigned to Ctrl-shift-s.

 

[bobsan42]

Are you sure you looked at the second link?

What does the Ctrl + Shift + Z keyboard shortcut?

Are you curious what Ctrl + Shift + Z does in 238 programs? Here is the list.

defkey.com

 

[TRMMolloy]

Check number 2 here:

What does the Ctrl + Shift + Z keyboard shortcut?

Are you curious what Ctrl + Shift + Z does in 238 programs? Here is the list.

defkey.com

Interesting .. Excel 2019. I just checked: My machine is running Excel For Office 365 MSO (16.0.12527) 64-bit

Now to look for "Excel 2019 Override ShortCut Keys"

Thanks for the link.