View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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