Читать книгу Excel Macros For Dummies онлайн
4 страница из 60
10 ssss1
11 About the Author
12 ssss1
13 ssss1
14 ssss1
List of Illustrations
1 Chapter 1FIGURE 1-1: The Record Macro dialog box.FIGURE 1-2: Your pre-totaled worksheet containing two tables.FIGURE 1-3: Your post-totaled worksheet.FIGURE 1-4: The Excel Macro dialog box.FIGURE 1-5: Recording a macro with relative references.FIGURE 1-6: The Trusted Locations window allows you to add directories that are...FIGURE 1-7: You can find the form controls on the Developer tab.FIGURE 1-8: Assign a macro to the newly added button.FIGURE 1-9: Adding a macro to the Quick Access Toolbar.FIGURE 1-10: Use macros to build buttons that help users navigate your reports.FIGURE 1-11: This report allows users to choose their perspective.FIGURE 1-12: The macros behind these buttons rearrange the data fields in a Piv...FIGURE 1-13: Offering prerecorded views not only saves time and effort, but it ...FIGURE 1-14: You can give your audience a choice in how they view data.
2 Chapter 2FIGURE 2-1: The VBE with significant elements identified.FIGURE 2-2: The Project Explorer with two projects open, expanded to show their...FIGURE 2-3: Code modules are visible in the Project Explorer in a folder called...FIGURE 2-4: The Editor tab in the Options dialog box.FIGURE 2-5: Change the way VBE’s looks with the Editor Format tab.FIGURE 2-6: The General tab of the Options dialog box.FIGURE 2-7: The Docking tab of the Options dialog box.