Use the Workbook_Open event. In Excel right click the Excel Icon just
left of the File Menu. Select View Code. Paste the following and change
as required:

Private Sub Workbook_Open()
MsgBox "Hello World!"
End Sub

Hope this helps
Rowan

Sangamesh Acharya wrote:
How to run a macro as soon a a workbook (.xls) is opened?