Also, be aware that the Developer tab will always be displayed in the ribbon from now on unless you either go back into Options and turn it off or re-install Excel.

Before creating a macro, activate the Developer tab in Microsoft Excel. This works on PC and Mac, but the steps to activate the Developer tab differ slightly from one operating system to the other.

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 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.

VBA sub procedures can perform lots of tasks and there are many ways to execute those functions in Microsoft Excel.

Discover how to automate Excel tasks with macros and VBA. Save time, reduce errors, and streamline your workflow without coding expertise.