Opens the Visual Basic editor, where you write and edit macros. Press Alt+F11 again to go back to the workbook. If you just want to run a macro, Alt+F8 is quicker.
More Workbook shortcuts
- Create a chart on a new sheetF11
- Close ExcelAlt+F4
- Close the workbookCtrl+W
- Format data as a tableCtrl+T
- Open the list of macrosAlt+F8
- Insert a new sheetShift+F11
- Create a new workbookCtrl+N
- Switch to the next open workbookCtrl+Tab
- Open a workbookCtrl+O
- Save the workbookCtrl+S
- Save as a new fileF12
- Show or hide the ribbonCtrl+F1