Читать книгу Excel Macros For Dummies онлайн
41 страница из 60
5 After both macros are set up, assign each one to a separate button.
You can run your new macros in turn to see your pivot field dynamically move back and forth.
Offering one-touch reporting options
The last two examples demonstrate that you can record any action that you find of value. That is, if you think users would appreciate a certain feature being automated for them, why not record a macro to do so?
In Figure 1-13, buttons are tied to macros that filter the PivotTable for the top or bottom 20 customers. Because the steps to filter a PivotTable for the top and bottom 20 have been recorded, users can get the benefit of this functionality without knowing how to do it themselves. Also, recording a specific action allows you to manage risk a bit. That is to say, your users can interact with your reports in a method that has been developed and tested by you.
ssss1 Offering prerecorded views not only saves time and effort, but it also allows users that don’t know how to use advanced features to benefit from them.