In the code for ThisWorkbook:

----

Private Sub Workbook_Open()
'your code here
End Sub

----

HTH
Anders Silven

"jpepper" skrev i meddelandet ...
I have a macro that I want to run automatically when the
user opens up the workbook and select enable macro. Does
anybody know how i can do that.

Thanks in Advance