Lesson 11 - Editing Macros
Writing a New Macro
Entering Macro Comments
Copying Macro Commands
Editing Macro Commands
Typing Macro Commands
Running a Macro from the Code Window
Lesson 12 - Using Custom Toolbars and Menus
Creating a Custom Toolbar
Adding/Removing Toolbar Buttons
Adding the Custom Button to a Toolbar
Assigning a Macro to a Button
Changing a Button Image
Displaying Button Text and Image
Attaching a Custom Toolbar
Deleting a Custom Toolbar
Creating a Custom Menu
Adding Custom Menu Commands
Workshop Information Page |
Lesson 13 - Creating Macro Buttons
Using a Macro Button
Creating a Macro Button
Copying a Macro Button
Formatting a Macro Button
Moving/Sizing a Macro Button
Deleting a Macro Button
Lesson 14 - Creating/Revising PivotTables
Creating a PivotTable Report
Adding PivotTable Report Fields
Selecting a Page Field Item
Refreshing a PivotTable Report
Changing the Summary Function
Adding New Fields to a PivotTable Report
Moving PivotTable Report Fields
Hiding/Unhiding PivotTable Report Items
Deleting PivotTable Report Fields
Creating a Page Field Report
Formatting a PivotTable Report
Creating a PivotChart Report
Publishing PivotTable Reports to the Web
Adding Fields to a PivotTable - Browser
Using a PivotTable List |
