What Is MS Excel Macro?
An Excel macro is a recording of each command and action performed to complete a task. Macros are recorded in Visual Basic, a programming language.
Other People Are Reading
-
Identification
-
Macros can be run by custom buttons on the toolbar, the menu bar, from a shape, from another macro or from a triggered event.
Benefits
-
A macro can automate a complex or often repeated task; this includes the entering, editing, moving and deleting of spreadsheet data. Macros created in one workbook can be copied to another.
-
Expert Insight
-
The Visual Basic Editor can be used to correct any errors or change the actions of a macro. A macro will not run if the macro security settings in the program are set too high.
Considerations
-
A macro can be certified with a digital signature which lets the recipient of the spreadsheet know that the macros are from a trustworthy source.
Warning
-
Harmful computer viruses can be embedded in macros and released when the macro is run. Macro viruses have the potential to destroy and delete computer files that are unrelated to the macro.
-
References
Resources
- Photo Credit Image by Flickr.com, courtesy of National Institute for Occupational Safety and Health (NIOSH)
