• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Enhancing Your Pivot Table R... > Altering a Recorded Macro to Add Fun...

Altering a Recorded Macro to Add Functionality

When you record a macro, Excel creates a module that stores the recorded steps of your actions. These recorded steps are actually lines of VBA code that make up your macro. You can add some interesting functionality to your pivot table reports by tweaking your macro's VBA code in order to achieve various effects.

To get a better understanding of how this works, start by creating a new macro that will extract the top five records by customer. Go up to the application menu and select Tools, Macro, Record New Macro. The dialog box shown in Figure 11.7 will be activated.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint