Course Outline: Recording Macros - Accessing the Developer Tag (2007 only)
- Naming conventions·and storage locations·
- Absolute and relative cell addressing
Running Macros· - Assigning macros to toolbar buttons· (2000, XP and 2003 only)
- Creating menus· (2000, XP and 2003 only)
- Assigning macros to the quick access toolbar (2007 only)
- Assigning macros to objects/buttons on the worksheet
Creating Macro Toolbars· (2000, XP and 2003 only) - Creating a custom toolbar·
- Adding macro buttons to the toolbar·
- Attaching the toolbar to a workbook·
Storing Macros in Workbooks (2007 only) - Recording macros in a specific workbook
- Saving the workbook as an Excel Macro-enabled Workbook
- Creating quick access items specific to workbooks
Macro Management· - Deleting macros·
- Setting macro options
- Macro security
The Visual Basic Environment· - Project explorer·
- Code window·
- Properties window
Working With Code· - Code structure·
- Adding comments·
- Navigating within your code·
- Editing macro code·
- Getting help with syntax
Commonly Used Commands· - Workbook and worksheet commands·
- Excel selection methods
Debugging· - Errors·
- Compiling·
- Using Debug
Function Procedures· - Function macros·
- Creating function macros as add-ins
|
