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

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

Covering the fundamentals of building and using macros is one thing. Coming up with good ways to incorporate them into your reporting processes is another. Take a moment to review a few examples of how macros automate simple reporting tasks.

One common use of macros is navigation. Workbooks that have many worksheets or tabs can be frustrating to navigate. To help your users, you can create some sort of a switchboard, similar to the one shown in Figure 1-10. When a user clicks the Example 1 button, he’s taken to the Example 1 sheet.

Creating a macro to navigate to a sheet is quite simple.

1 Start at the sheet that will become your switchboard or starting point.

2 Start recording a macro.

3 While recording, click the destination sheet (the sheet this macro will navigate to).

4 After you click in the destination sheet, stop recording the macro.

5 Assign the macro to a button.

ssss1 Use macros to build buttons that help users navigate your reports.