Word and Excel 2007 creating macros seem useless

[DougP]

I have tried creating various macros by clicking Create new macro and the choosing whatever I wanted with the mouse or keyboard.
2003 and back let me record just about anything. I have a lot of macros I have made over the decades using the last 7 or 8 versions of Office.
In Word 2007 when I clicked something using the mouse it either does nothing at all or when I open the macro it was completely blank. just a heading and Sub end sub.

Am I missing something, I need to turn on?
Or do you have to scour the WEB to get the VBA code and paste it in yourself and build if all from scratch.

DougP

 

[tf1]

In Uninstall or Change a Program, select Microsoft Office and choose Change, Add/Remove Features . Under 'Shared Item' (I think it's in that group) make sure that VBA has been checked as Run on this Computer.

VBA isn't installed by default.

Regards: Terry

 

[DougP]

The problem is not that I can't find the record button????
its the record button does nothing like it used to in 2003!!!!

and I can go into the VBA editor just fine. but Word 2007 does not seem to do anything worth while
Try it for yourself...
make a macro to change the borders on a image for example.
you can't right click the image while the macro Arrow cassette tape thingy is showing. it disables right clicking.
Works perfect in 2003 but not in 2007.


DougP

 

[SkipVought]

I am able to record a macro in Word

Sub Macro1()
'
' Macro1 Macro
'
'
    ActiveDocument.Shapes.AddShape(msoShapeRectangle, 94.4, 76.4, 47.6, _
        21.6).Select
    Selection.ShapeRange.Shadow.Type = msoShadow2
    Selection.ShapeRange.Fill.ForeColor.ObjectThemeColor = wdThemeColorAccent5
    Selection.ShapeRange.Fill.ForeColor.TintAndShade = 0#
    Selection.ShapeRange.Fill.Visible = msoTrue
    Selection.ShapeRange.Fill.Solid
End Sub

Don't know what your problem is.

Did you turn on the Developer TAB?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}