Microsoft Office Tutorials and References
In Depth Information
▪ Macros are handy tools that you can use to perform repetitive tasks quickly, such as
inserting blocks of text.
▪ You don’t have to be a programmer to use macros; you can record your actions and
have Excel save them as a macro.
▪ Excel uses macro-enabled workbook types, which have the file extensions .xlsm
(a macro-enabled workbook) and .xltm (a macro-enabled template workbook).
▪ If you’re curious about what a macro looks like, you can display it in the Visual Basic
Editor. If you know a little VBA, or if you just want to experiment, feel free to modify
the macro code to find out what happens.
▪ You can create Quick Access Toolbar buttons and shapes that, when clicked, run a
▪ If you want a macro to run whenever you open a workbook, create a macro named
▪ UserForms provide a customizable interface for data entry.