Click Stop Recording on either the Developer tab or the Status bar.This will ensure that all the formatting applis to the selection, not a specific range. Do not select any cells after you've started recording the macro. For this example, we use the bold text formatting, light blue fill color and center alignment. Format the pre-selected cells the way you want.For Description, use the following text explaining what the macro does: Makes text bold, adds fill color, and centers.
Choose to store the macro in this workbook.This will assign the Ctrl + Shift + F shortcut to the macro.
Place the cursor in the Shortcut key box, and press Shift + F keys simultaneously.Name the macro Header_Formatting (because we are going to format column headers).In the Record Macro dialog box, configure the following settings:.On the Developer tab or Status bar, click Record Macro.Select one or more cells that you want to format.To see how it works in practice, let's record a macro that applies some formatting to the selected cells. Or the analogous button on the Status bar: When finished, click the Stop Recording button on the Developer tab:.Perform the actions that you want to automate (please see the recording macro example).When you create a lot of different macros, it will help you quickly understand what each macro does. Though this field is optional, I'd recommend you always provide a brief description. In the Description box, type a short description of what your macro does (optional).New Workbook – creates a new workbook and records the macro to that workbook.This Workbook (default) - the macro will be stored in the current workbook and will be available when you reopen the workbook or share it with other users.All the macros stored in this workbook are available whenever you use Excel.
#RECORDING BUTTON ON DEVELOPER TAB EXCEL CODE#
On the Developer tab, in the Code group, click the Record Macro button.Īlternatively, click the Record Macro button on the left side of the Status bar:.To record a macro in Excel, carry out these steps: So, the first thing you need to do is to add Developer tab to your Excel ribbon. Like other VBA tools, Excel macros reside on the Developer tab, which is hidden by default.