Contents

About the Author

About the Technical Reviewer

Acknowledgments

Introduction

CHAPTER 1 The Macro Recorder and Code Modules

                       Macro Security Settings

                             Trusted Publishers

                             Trusted Locations

                             The Remove Button

                             Lowering the Security Level

                       The Visual Basic Development Environment

                             The Immediate Window

                             The Locals Window

                             The Watch Window

                       Recording a Macro

                             Formatting the Table

                             Adding Totals

                             Same ...

Get Pro Excel 2007 VBA 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.

Start your free trial