Excel 2007 Macro Recorder not recording shapes

[jaanbazz]

Hello,
I am trying to figure out why my Excel macro recorder is not recording creatio
of any shapes or changes to existing shapes. I started the macro, and drew
rectangle and stopped it. This is all the code I get. I like to see the synta
for shapes and I am unable to see maybe there is some problem with macr
recorder. Please help! Thanks!

Sub Macro1()
'
' Macro3 Macro
'
'
ActiveWindow.SmallScroll Down:=25
End Sub

Regards,
Jaan

 

[perl Newbie]

Hello,
I am trying to figure out why my Excel macro recorder is not recording creation
of any shapes or changes to existing shapes.  I started the macro, and drew a
rectangle and stopped it.  This is all the code I get.  I like to seethe syntax
for shapes and I am unable to see maybe there is some problem with macro
recorder.  Please help!  Thanks!

Sub Macro1()
'
' Macro3 Macro
'
'
    ActiveWindow.SmallScroll Down:=25
End Sub

Regards,
Jaan

You cannot record new shapes, shape formatting, and shape effects by
using the macro recorder in Excel 2007

http://support.microsoft.com/kb/937620