Alt+F11: Microsoft Visual Basic for Applications Editor

The shortcut Alt+F11 is to open the "Microsoft Visual Basic for Applications Editor" for Macros. Please see below for steps:

Step 1: Click anywhere in the worksheet;

Step 2: Press and hold the "Alt" key from the keyboard, and click "F11";

Alternatively, you can always use the command to open the Microsoft Visual Basic for Applications Editor with the steps below:

Step 1: Click the "File" tab from the ribbon;

Step 2: Click the "Options" command from the navigation list;

Step 3: In the "Excel Options" dialog box, click "Customize Ribbon" from the left menu, and select "Main" in the command box;

Select "Developer" and click "Add" to move "Developer" to the right box. This is to bring the "Developer" tab to the ribbon;

Step 4: In the "Developer" tab from the ribbon, click the "Visual Basic" command and the Microsoft Visual Basic for Applications Editor will open.

Leave a Reply