One of the less than useful new “features” of Excel 2007 is that its macro recorder no longer records operations on shapes, which removes the easiest way to discover the exact names of shape properties, and how to manipulate them. The file ShapeProps.zip contains a spreadheet with a User Defined Function (UDF) that will return a list of property names, and the values for each property, for any named shape. In addition it will generate VBA code to read aditional properties if the correct property names are inserted in a list on the spreadsheet.
The UDF currently reads 94 different properties, which can either be returned as a column array of all 94 values, or if a list of property numbers is entered only the listed property values will be returned. See the screen shot below for examples.