Unfortunately Excel 2007's macro recorder does not record many actions to
objects such as Shapes and Charts, as you've noticed. If you have Excel 2003
available you are lucky!

However there are quite a lot of new format properties for objects in 2007
which are unknown in earlier versions. Best way to find these is in Excel
2007 fully to declare your object variables, eg
Dim shp as Shape
Dim cht as Chart
Dim sr as Series

Type shp. and look at the intellisense after typing the dot. When you see
something that looks promising complete it, select it and F1 to see more
about it in help.

Also look in Object Browser, F2

Regards,
Peter T


"Mehdi" wrote in message
...
Excel 2007 does not save anything in macro when manipulating objects, but
excel 2003 does. Is there anything wrong with Excel 2007? How to overcome
this hassle?