Excel 2003 Macros
Three Hour Class

Basic Excel spreadsheet skills are a prerequisite to take this class. Students will learn how to record and use macros. How to open a workbook using macros and how to assign a macro to a menu or button. Also creating a macro button and custom menus will be covered in this class.

Define Macros
Open a Workbook Containing Macros
Use a Shortcut Key
Use the Visual Basic Toolbar
Record Macros
Use Relative References
Assign a Macro to a Menu
Edit Macros
Record a Personal Macro
Hide the Personal Macro Workbook
Debug Macros
Set a Breakpoint

Enter a Macro Comment
Correct a Statement Error
Use Statement Color Codes
Use Custom Functions
Insert a Macro Module
Use the Paste Function Button
Create Custom Toolbars and Buttons
Assign a Macro to a Button
Change Button Text and Image
Attach a Custom Toolbar
Create a Macro Button
Create Custom Menus