I have a single powerpoint slide I am trying to run when I open the Excel workbook.

It has run, but it causes this 1004 error 50% of the time. It always does the 1004 error on the first attempt to open the workbook.

I have added the ppt slide as an editable object.

This is the macro I have made to run it - auto on opening the work book.

Can anyone see why/where its wrong ?

Sub Auto_Open()
'
' Auto_Open Macro
'
'
    ActiveSheet.Shapes.Range(Array("Object 3")).Select
    Selection.Verb Verb:=xlPrimary
    
    Sheets("Home").Select
    Range("A10").Select
End Sub