Why does Excel macro recorder no longer recor

Microsoft Microsoft office excel 2007 -...
December 10, 2010 at 12:41:25
Specs: Windows XP
Why does Excel macro recorderder no longer record everything I do. For example, if I add a shape and change the formatting, the recorded vb code shows nothing. In the old Excel it would show all the details.

See More: Why does Excel macro recorder no longer recor

Report •

December 10, 2010 at 13:36:49
What do you mean by "In the old Excel..."

Did you just recently upgrade or re-install Excel? Has it ever worked for you in Excel 2007?

Maybe this link (<-- Click) will help.

Posting Tip: Before posting Data or VBA Code, read this How-To.

Report •

January 4, 2011 at 10:50:38
I am now using Excel 2007.

I looked at the link you suggested, but this didn't help.

If I record a test macro and manipulate some cells in a worksheet, the macro seems to track the changes fine. However, if for example I format the properties of a shape that I've added, then the macro shows nothing.
I used to use the macro record facility to find out what colours and shapes were written as in VB, now I'm lost!

Report •

January 9, 2011 at 09:01:24
I can't say where your problem is.

I do know that the macro recorder doesn't record everything but here's what I just did:

I inserted a shape (a chord) in Excel 2010 and then started the macro recorder.

I selected the shape and choose Format shape. After playing around I stopped the recorder and got this:

Sub Macro1()
' Macro1 Macro

    ActiveSheet.Shapes.Range(Array("Chord 1")).Select
    With Selection.ShapeRange.Glow
        .Color.ObjectThemeColor = msoThemeColorAccent1
        .Color.TintAndShade = 0
        .Color.Brightness = 0
        .Transparency = 0.599999994
        .Radius = 123
    End With
    With Selection.ShapeRange.Line
        .Visible = msoTrue
        .ForeColor.RGB = RGB(255, 0, 0)
        .Transparency = 0
    End With
    With Selection.ShapeRange.Shadow
        .Type = msoShadow25
        .Visible = msoTrue
        .Style = msoShadowStyleOuterShadow
        .Blur = 70
        .OffsetX = 2.4492935983E-16
        .OffsetY = 4
        .RotateWithShape = msoFalse
        .ForeColor.RGB = RGB(0, 0, 0)
        .Transparency = 0.5686300099
        .Size = 100
    End With
End Sub

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

January 12, 2011 at 09:24:47

The code recorded by your test is the sort of thing I was expecting. However, when using my machine, it doesn't record that information.
I am wondering whether it might be something to do with the corporate setup of the machine that I am using. I just tried an older machine, with Excel 2003, and that seemed to work, but doesn't work on my machine with 2007.

Report •

January 12, 2011 at 11:05:42
Just a thought,
Excel 2007 has a Macro Security feature

On the Task Bar/Ribbon look under the Developer Tab
Select the Macro Security button

There are a number of options that could impact your use of Macros.



Report •

Ask Question