Microsoft Office Tutorials and References
In Depth Information
Key Points
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
a macro.
If you want a macro to run whenever you open a workbook, create a macro named
Auto_Open.
Search JabSto ::




Custom Search