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.

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.

Method one: How to run a VBA sub procedure from the Developer and View tabs in Excel Excel’s .xlsx ribbon has been with us for a long time, but you might not know about the Developer tab because ...

You can run a Macro in Excel by clicking the macros command on the Developer tab, using a combination shortcut key, by clicking on a graphic object, etc.

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you.

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.

Access the Developer tab in Excel to write and run VBA code. Create a new VBA module to house your automation code. The PageSetup object is essential for customizing headers and footers.