Hi,
You can have a macro run when you use a workbook open event.
As for books look on amazon. They have a great selection of books.
Code:
Private Sub Workbook_Open()
''' This code needs to be in the "Thisworkbook module
Run "MyMacro"''' this will call the code you want to run
End Sub