Microsoft Office Tutorials and References
In Depth Information
● Macros are handy tools 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 and see what happens.
● You can create Quick Access Toolbar buttons and shapes that, when clicked, run
● If you want a macro to run whenever you open a workbook, create a macro named