Edgar,

1. In the Project Explorer window, double-click "ThisWorkbook"
2. Create a Workbook_Open procedure, something similar to this:

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

3. Save the workbook.

Ture Magnusson
Karlstad, Sweden

"Edgar" wrote in message
...
Hi

I was wondering how automatically run a macro everytime i
open a workbook.

Thanks