Читать книгу Excel Macros For Dummies онлайн
42 страница из 60
This not only saves them time and effort, but it also allows users that don’t know how to take these actions to benefit from them.
Figure 1-14 demonstrates how you can give your audience a quick and easy way to see the same data on different charts. It’s not uncommon to be asked to see the same data different ways. Instead of taking up real estate by showing both charts, just record a macro that changes the Chart Type of the chart. Your clients can switch views to their heart’s content.
ssss1 You can give your audience a choice in how they view data.
Chapter 2
Getting Cozy with the Visual Basic Editor
IN THIS CHAPTER
The Visual Basic Editor (VBE) is the environment where all Excel macros are written or recorded. The VBE is included with Excel free of charge. Even if you never record one macro, the VBE is in the background waiting to be used. When you create a macro, the VBE quietly comes to life ready to process the various procedures and routines you give it.