panaarchive.blogg.se

This and the other macros are in my Personal Macro Workbook (personal.xlsb), and those macros are always active.Īs 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. Trust Center Macro Security Setting: Enable All Macros

So something is preventing Ctrl Shift z from working (Ctrl Shift d, too), I just don't know where to look. I confirmed again that Ctrl Shift s runs the macro, Ctrl Shift z will not. Confirmed Ctrl Shift z assigned to Macro1 in Macro Options window Closed Excel (saving Personal Macro Workbook) Confirmed that Macro1 works by running Personal.xlsb!Macro1 from the Macro window. assigned Ctrl Shift z to Macro1 in Macro Options window opened Excel, confirmed no shortcut was assigned to Macro1 in Macro Options window closed Excel (saving Personal Macro Workbook) deleted shift z in the Macro Options window I ran through the usual sequence of confirming something was wrong: Confirmed the macro works by using Macro window Run command on "PERSONAL.XLSB!Macro1" Shift z in the option box)ĪctiveCell.FormulaR1C1 = "Hi there. Recorded a new macro, setting the shortcut key to Ctrl Shift z (i.e. Opened Excel, confirmed that there were no macros.Ĥ. Closed Excel, backed up personal.xlsb, erased it from the Excel Startup directory.ģ. So I ran a test (TLDR: demonstrating each step I took to solve problem):ġ. I tried all of the suggestions in the various threads on MrExcel and elsewhere to no avail.

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 have about 15 macro shortcut keys in Personal.xlsb to do simple tasks, but they are slowly but surely starting to be disabled.