These step-by-step instructions show you how to add the Developer tab to the Ribbon in Word and Excel 2016 and Office 365, and to use it to launch the Visual Basic Editor and access Visual Basic ...

Once you know what macros you'd like to set up and have the Developer tab ready, here's what to do in Excel on Windows or macOS: Click the Developer tab and find the Code group.

First, you must enable the "Developer" tab on the ribbon menu in Excel. To do so, right-click the ribbon menu and click "Customize the Ribbon" in the pop-up menu.

To enable the Developer tab, open Excel and go to the File menu. From there, select Options, then Customize Ribbon. In the right pane of the dialog box that appears, check the Developer box.

First, enable the Developer tab, then create a Macro. After that, save it as an Excel Macro-Enabled Workbook for Microsoft Excel Spreadsheet and a Word Macro-Enabled Document for Microsoft Word.

To start using macros, you’ll need to enable the Developer tab in Excel. This tab provides access to the tools required for recording and managing macros.

Step 1: Enable Developer Tab To work with macros, you’ll need to enable the Developer tab, which is hidden from the Ribbon by default.

Enable the Developer Tab Launch Microsoft Excel on your computer. Click the "File" tab on the ribbon bar, then the "Options" link.