How to open Excel’s Developer tab and the Visual Basic Editor

Excel’s Developer tab does not show by default, so if you want to record macros or write macro code in VBA in the Visual Basic Editor, you’ll need to activate it

Open Excel’s File menu and click Options

Excel - Options in File menu
Excel – Options in File menu

Click Customize Ribbon

Excel - Customize Ribbon
Excel – click Customize Ribbon

Check the Developer box and click OK

Excel - check Developer box
Excel – check Developer box

Check the Developer tab…

Excel - click Developer tab
Excel – click Developer tab

To open the Visual Basic Editor, click the Visual Basic button, or shortcut keys ALT + F11.

Excel's Visual Basic Editor
Excel’s Visual Basic Editor