Making the Developer Menu Tab Visible
1. Click the File menu tab in the menu ribbon at the top left of the screen.
2. Click the More option in the menu on the left side of the screen to display additional options.
3. Click the Options option to display the Options window.
4. Click the Customize Ribbon option in the menu on the left side of the screen.
5. Click the check box for Developer in the Customize the Ribbon menu on the right side of the screen.
6. Click the OK button at the bottom right of the window. You should now be able to see the Developer menu tab between the View and Help menu tabs in the menu ribbon at the top of page.
Opening the Visual Basic Editor
1. Click the Developer menu tab at the top of the screen.
2. Click the Visual Basic button at the top left of the screen.
Inserting a VBA Module
1. Right-click the appropriate project found in the Projects window on the left side of the screen.
2. Click on the Insert option.
3. Click the Module option to display the Code window. The Code window is the part of the VBE where you can enter VBA code.