The following code works in Excel 2003, but not in Excel 2010:

    mSheet = ActiveSheet.Shapes(Application.Caller).AlternativeText
The application dynamically creates several "buttons" on a worksheet and assigns them unique values to the .Name and .AlternativeText properties. The above code is executed when any of the buttons is pressed.

Under 2003, the above line of code retrieves the correct .AlternativeText value for the button pressed.

Under 2010, the above line of code retrieves the .AlternativeText value for the first button created, no matter which button is pressed. ...same for the .Name property.