Recording a macro in excel 2007

[petersto]

I want to record a macro for adding a shape (arrow) and then adding black squares into the shaft of the arrow. Finally to group all and rename the group. Such things were simple in excel 2003 but nothing is recorded in excel 2007. Has the ability to record a macro involving shapes been removed in this version? If so it certainly doesn't seem to be an improvement. Any help or advice greatly appreciated.

 

[Amnesiac]

In Microsoft Office Excel 2007, you cannot record new shapes, shape formatting, and shape effects by using the macro recorder. For example, you cannot record chart elements, fill-in colors, line styles, and line effects by using the macro recorder.

To work around this behavior, use Microsoft Visual Basic for Applications (VBA) code to format the shapes.