Читать книгу Excel Macros For Dummies онлайн

6 страница из 60

5 Chapter 5FIGURE 5-1: Omit the Application.DisplayAlerts = False line in the macro to ens...FIGURE 5-2: Without a macro, you’re stuck using Excel’s Unhide dialog box to un...FIGURE 5-3: It’s often useful to have your worksheets sorted in alphabetical or...FIGURE 5-4: You can right-click any worksheet to choose a tab color for the she...FIGURE 5-5: The Protect Sheet command is disabled if you try to protect more th...FIGURE 5-6: The Unprotect Sheet command is disabled if you try to unprotect mor...FIGURE 5-7: A table of contents can help you more easily navigate your workbook...FIGURE 5-8: Type or paste your code into the Worksheet_BeforeDoubleClick event ...FIGURE 5-9: A highlighted row and column makes it easy to track data horizontal...

6 Chapter 6FIGURE 6-1: Click the Define Name command to name a chosen range.FIGURE 6-2: Give your range a name.FIGURE 6-3: The Name Manager dialog box lists all the applied named ranges.FIGURE 6-4: Type or paste your code in the Workbook Open event Code pane.FIGURE 6-5: The Go To Special dialog box.FIGURE 6-6: Choosing Formulas in the Go To Special dialog box tells Excel to se...FIGURE 6-7: You can use a macro to tell Excel to dynamically find the first ava...