7. What Is New in Excel 2010 and What Has Changed
IN THIS CHAPTER
If It Has Changed in the Front End, It Has Changed in VBA
If It Has Changed in the Front End, It Has 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.
→ See Chapter 8, “Create and Manipulate Names in VBA,” for more information on working with names.
The Ribbon
If you have been working with a legacy version of Excel, the Ribbon is one of the first changes you’ll notice when you open Excel 2010. Although the CommandBars object does still work to a point, ...
Get VBA and Macros: Microsoft® Excel® 2010 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.
