Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 7. What’s New in Excel 2007 and What’s Changed

IN THIS CHAPTER

If It’s Changed in the Front End, It’s Changed in VBA	135
The Macro Recorder Won’t Record Actions That It Did Record in Earlier Excel Versions	138
Learning the New Objects and Methods	139
Compatibility Mode	140
Next Steps	142

If It’s Changed in the Front End, It’s Changed in VBA

Thankfully, not too much of VBA doesn’t work anymore, but a few things in the object model have changed. For most items, it’s obvious that, because the Excel user interface changed, the VBA has changed.

Note

The New graphic is used throughout the book to point out those sections discussing items ...