Macros can help you automate repetitive tasks and save time. You can use the macro recorder to record the macro or write your own macro script in VBA.
Watch this video to see how to edit a macro in a special text editor called the Visual Basic Editor. Visual Basic is the programming language that macros are recorded in.
To make sure your macro is always available on your computer, save it to your Personal Macro Workbook, which is a special hidden workbook that loads every time you start Excel.
In this final video, we’ll hook the macro up with a button and make it available in two places: In a custom group on the Developer tab, and on the Quick Access Toolbar.
In Excel, you can set a macro security level to control what happens when you open a workbook that contains a macro. For example, you can choose to run macros based on whether they