Lesson 1: Customizing Excel Workspaces
Setting Options
Customizing Toolbars
Arranging and Saving Workspaces
Lesson 2: Customizing Startup
Opening Workbooks at Startup
Opening Custom Worspaces at Startup
Creating Desktop Icons
Lesson 3: Collaborating with Workgroups
Creating Templates
Editing Templates
Creating AutoTemplates
Collaborating with Workgroups
Lesson 4: Using AutoFormats in Worksheets and
Charts
Using Built-in AutoFormats
Creating Custom Chart Formats
Lesson 5: Controlling Macros
Controlling Macro Cell references
Saving Macros for Selective Use
Lesson 6: Editing Macros
Opening the Visual Basic Environment
Inserting Procedures
Finding and Replacing Code
Deleting and Copying Code
Adding Comments
Lesson 7: Running Macros from Menus and Buttons
Assigning Macros to the Menu Bar
Assigning Macros to Toolbar Buttons
Assigning Macros to Worksheet Buttons
Changing Assigned Macros
Lesson 8: Making Macros Interactive
Displaying Dialog Boxes in Macros
Displaying Message Boxes in Macros
Lesson 9: Using Break Mode
Inserting Breakpoints
Inserting Stop Statements
Lesson 10: Stepping Through Macros
Stepping over Procedures
Stepping into Procedures
|
