CHAPTER 11Programming a Pivot Table
Although you can create complex pivot tables without programming, some pivot table settings can only be changed by using programming. As a developer, you can use programming to limit the ways users can manipulate your pivot tables, or to simplify a complex set of tasks. For example, you can provide a button on the worksheet that users can click to format, refresh, and preview a pivot table before printing.
This chapter addresses programming issues related to pivot tables and provides code examples for macros that can't be recorded. The chapter begins with a brief introduction to using Excel's macro recorder and the Visual Basic Editor (VBE), where you can view and edit the code stored in the workbook's modules. ...
Get Excel 2007 PivotTables Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
