O'Reilly logo

VBA and Macros: Microsoft® Excel® 2010 by Tracy Syrstad, Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

7. What Is New in Excel 2010 and What Has Changed

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required