Hi OlieH.........
Glad you got it sorted for your use..........
BTW, this version works fine if put in the WorkbookModule

Private Sub Workbook_Open()
MsgBox "Workbook Open, worked"
End Sub

Vaya con Dios,
Chuck, CABGx3



"OlieH" wrote:



"OlieH" wrote:

I would like to automatically run a specific maco when the workbook is opened.
I am running XP Pro with Office XP.
Thanks for all help.

Thank you both for the help. Otto, I named the macro as you suggested and
it worked fine. I did try the Private sub Workbook_open, but I must have
done something wrong, since the macro did not fun.
Private Sub Workbook_Open()
ans = MsgBox("workbook_open worked")
End Sub
did not open for me.