CHAPTER 1The Macro Recorder andCode Modules

This book is written for experienced coders. You may have experience in many languages, but not in the Excel (or Office) VBA IDE. We will be writing quite a bit of code as we move along, but before we do that, let's take a quick look at Excel's Macro Recorder and the Visual Basic Development Environment. The Macro Recorder has been a part of Excel for quite a long time, and it's still the best way to get a look at some of the objects that make up the Excel Document Object Model (DOM), and a great way to get the core of your code written for you as you start your development projects.

Macro Security Settings

Excel's default security settings do not allow any macro activity. Before you begin exploring ...

Get Pro Excel 2007 VBA now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.