-
On the Developer tab, select Visual Basic, or press fn+Option+F11.
-
If you don't see the Developer tab, select Excel at the top of the screen.
-
Select Preferences and choose Ribbon & Toolbar.
-
In the Customize the Ribbon pane, select the Developer check box under Main Tabs. Select Save.
Opening the Visual Basic editor isn't currently possible in Excel for the web. You can, however, open the Visual Basic editor in the Excel desktop app.
-
To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.
Don't have the Excel desktop app? Try or buy Microsoft 365.