Microsoft Office Tutorials and References
In Depth Information
Key points
Key points
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
macro.
If you want a macro to run whenever you open a workbook, create a macro named
Auto_Open.
UserForms provide a customizable interface for data entry.
12
 
Search JabSto ::




Custom Search