Run a Macro automatically when opening a file

Open the workbook that you would like to have code run when you open it. Go to the VB editor and, in the Project window, double-click on "This Workbook" (make sure it's the right one if you have more than one open). The code window should open, and above it should be 2 pull-down menus. In the one on the left, select "workbook". This should add the code:

Private Sub Workbook_Open()

End Sub

To your code window automatically. Either type your code in or call the function from there.

Hope this helps,

Russell