To enable Ctrl-m, repeat the same sequence of steps except that you need to insert EnableToolsShortcut as the macro name. Next insert the macro name DisableToolsShortcut in the Macro dialog box that appears and press the Run button. To disable Ctrl-m, press Alt-F8 (or select View > Macros|Macros).
In this case, you will need to use choose Real Statistics Data Analysis Tools from the Add-Ins ribbon to display this dialog box. This is the easiest approach since it can be done in all versions of Excel (Windows and Mac) no matter which Excel ribbon is active.įigure 1 – Data analysis tools dialog box (main menu)įor those of you who use the keyboard shortcut Ctrl-m for some other purpose, you can disable Crtl-m from being used as a way to display the dialog box for Real Statistics data analysis tools. You can access the dialog box which lets you choose one of the Real Statistics data analysis tools by pressing Ctrl-m. The first approach is also available for the Mac. On this webpage, we present a number of ways for accessing the Real Statistics data analysis tools in the Windows environment.
