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.
0 kommentar(er)
