![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |