I am unable to record macros that move or format objects - ovals, rectangles,
etc.

Macro security hsd been set to "enable all"


--
MM

What occurs when you attempt to record a macro performing manipulation of an
object?

Does the recorder work properly for purposes other than moving or formatting
objects?


Gord Dibben MS Excel MVP

On Sat, 1 Mar 2008 10:46:01 -0800, MM <MM@discussions. microsoft.com wrote:

I am unable to record macros that move or format objects - ovals, rectangles,
etc.

Macro security hsd been set to "enable all"

Yes everything else records properly
--
MM


"Gord Dibben" wrote:

What occurs when you attempt to record a macro performing manipulation of an
object?

Does the recorder work properly for purposes other than moving or formatting
objects?


Gord Dibben MS Excel MVP

On Sat, 1 Mar 2008 10:46:01 -0800, MM <MM@discussions. microsoft.com wrote:

I am unable to record macros that move or format objects - ovals, rectangles,
etc.

Macro security hsd been set to "enable all"

Please answer the first question.

Thank, Gord

On Sat, 1 Mar 2008 11:36:01 -0800, MM wrote:

Yes everything else records properly
--
MM


"Gord Dibben" wrote:

What occurs when you attempt to record a macro performing manipulation of an
object?

Does the recorder work properly for purposes other than moving or formatting
objects?


Gord Dibben MS Excel MVP

On Sat, 1 Mar 2008 10:46:01 -0800, MM <MM@discussions. microsoft.com wrote:

I am unable to record macros that move or format objects - ovals, rectangles,
etc.

Macro security hsd been set to "enable all"

It does not record anything related to the object
--
MM


"Gord Dibben" wrote:

Please answer the first question.

Thank, Gord

On Sat, 1 Mar 2008 11:36:01 -0800, MM wrote:

Yes everything else records properly
--
MM


"Gord Dibben" wrote:

What occurs when you attempt to record a macro performing manipulation of an
object?

Does the recorder work properly for purposes other than moving or formatting
objects?


Gord Dibben MS Excel MVP

On Sat, 1 Mar 2008 10:46:01 -0800, MM <MM@discussions. microsoft.com wrote:

I am unable to record macros that move or format objects - ovals, rectangles,
etc.

Macro security hsd been set to "enable all"

Nothing like this which is what I get when I record?

Sub Macro4()
Application.CommandBars("Drawing").Visible = True
ActiveSheet.Shapes.AddShape(msoShapeRectangle, _
143.25, 11.25, 170.25, 96.75).Select
Range("D13").Select
ActiveSheet.Shapes.AddShape(msoShapeOval, 478.5, 34.5, 174.75, 123#).Select
Range("G12").Select
ActiveSheet.Shapes("Rectangle 1").Select
Selection.ShapeRange.ScaleWidth 1.31, msoFalse, msoScaleFromBottomRight
Selection.ShapeRange.ScaleHeight 1.62, msoFalse, msoScaleFromTopLeft
ActiveSheet.Shapes("Oval 2").Select
Selection.ShapeRange.ScaleHeight 1.77, msoFalse, msoScaleFromTopLeft
Selection.Copy
Range("D23").Select
ActiveSheet.Paste
End Sub

I wouldn't know where to start troubleshooting.

Do you get any error messages?

Do you get the Sub Macro#() and the who and when lines then just End Sub?

Are you recording in the active workbook/worksheet in a single instance of
Excel?

Any ideas out there?

I guess that is a start at troubleshooting after all<g


Gord


On Sat, 1 Mar 2008 14:21:01 -0800, MM wrote:

It does not record anything related to the object