Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Record macro doesn't record shape properties
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Record macro doesn't record shape properties
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 "Tosco" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Record macro doesn't record shape properties
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
Record the date on which the record is made | Excel Programming | |||
Finding last record in month for each of several types of record. | Excel Programming | |||
Record Macro - Record custom user actions | Excel Programming | |||
Need help autopopulating next new record with previous record data | Excel Programming |