Hi All,

I wanted to have a macro that would insert a Word Doc object into the active sheet, then insert a table into the object. I tried a basic "Record Macro" but once the imbedded Word Doc is created, I lose the macro buttons until I click back into the worksheet so my creation of the table within the Word doc is not recorded. Anyone have a way around this? Thanks in advance.

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 9/14/2007
'

'
    ActiveSheet.OLEObjects.Add(ClassType:="Word.Document.8", Link:=False, _
        DisplayAsIcon:=False).Activate
    ActiveCell.Offset(4, 0).Range("A1").Select  'This happens after I created the table, I clicked back into the worksheet.
    ActiveSheet.Shapes("Object 2").Select 'Also when I reclick on the object, it gives the specific object name which wouldn't work in a macro.
    
End Sub