Automatic Macro Start

[Edgar]

Hi

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

Thanks

 

[Ture Magnusson]

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