CHAPTER 13Programming 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 that 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 will address programming issues related to pivot tables and provide 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 code is stored. Many excellent books are available with ...
Get Excel Pivot Tables Recipe Book: 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.
