Record macro doesn't record shape properties

[Tosco]

I recorded a macro while editing a bitmap and the macro in the VBA
Editor is empty.
I tried to perform other actions like entering some text in some cells
and those actions are recorded.

Is this a regression of Excel 2007?
Or am I doing something wrong?

Thanks

 

[Guest]

hi,
no, your are not doing anything wrong. some thing can't be recorded. in your
case, editing a bitmap. this cannot be done in VB. VB can manipulate an image
to some degree but it is limited. call up the picture tool bar. this actions
can be recorded. others can't. The recorder is a useful tool but it has
limits. and when you hit a limit.... oh well, time to post to communities.

Regards
FSt1

 

[NickHK]

Stefano,
Depends what you mean by "editing". XL2002 gave means this slightly edited
macro on playing with a graphic.
I understand XL2007 may not record all the same actions on graphics and
charts as previous versions, although previous code should run.
Maybe record a macro in an earlier version of Excel, if you have one
available.

Sub Macro1()
With Selection.ShapeRange
.IncrementLeft 165#
.IncrementTop 39#
.ScaleWidth 0.73, msoFalse, msoScaleFromTopLeft
.ScaleHeight 0.74, msoFalse, msoScaleFromBottomRight
.PictureFormat.IncrementContrast 0.03
.PictureFormat.IncrementBrightness 0.03
.PictureFormat.CropBottom = 20.38
.IncrementRotation -90#
.Line.Weight = 2.25
.Line.Visible = msoTrue
.Line.Style = msoLineSingle
.PictureFormat.TransparentBackground = msoTrue
.PictureFormat.TransparencyColor = RGB(14, 128, 190)
.Fill.Visible = msoFalse
End With
End Sub

NickHK

"Tosco"

 

[Tosco]

Usually the priority for fixing a bug is hihger when it is a
regression, and this is a regression because in the previous version
it was working.
Creating a macro to maniplate graphics, shapes and other objects can
be very time expensive without the recorder.
Does anybody know if there are plans of fixing it?