How to enable macro in excel sheet
#1) Macro name: Name should not have spaces in between words. This will open up a window where you need to enter. Navigate to the Developer tab, and hit on Record Macro. Instead of doing this manually every week, you can just create a macro and perform all these actions in just a click.
Once you enable the Developer Tab, it will always be shown in a custom ribbon for every Excel instance you open, unless you go ahead and disable it explicitly. This tab is hidden by default.įollow the below steps to unhide the Developer tab.
HOW TO ENABLE MACRO IN EXCEL SHEET CODE
The Developer tab gives us the ability to work with features like Macros, Add-ins, and also allows us to write our own VBA code that will help us to automate anything we wish. Then you can create and run a macro that applies these formatting changes every time you wish to. Suppose every month you create a report that needs to mark the user accounts with the overdue amount in bold and red.