Record macro doesn't record shape properties
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"
wrote in message
ups.com...
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
|