Bill,
Once you have stopped recording, hit "Alt F11" and go into the VBA Editor. You should have the Project Explorer on the left side of the window. To get the Project Explorer if you do not have it showing, hit "Ctrl-r". Click on the Modules folder and then click on Module1. You should see the macro that you recorded on the right side of the window. Copy everything in your macro except for the first line, which probably says "Sub Macro1 ()" and the last line that says "End Sub"
Back in the Project Explorer, you will see the Microsoft Excel Objects folder. Within this folder, you will see "This Workbook". When you double click this item in the Project Explorer, the right side of the window will be blank. In the right side blank area, Type this and hit enter:
Code:
Private Sub Workbook_Open ()
When you hit enter, it automatically adds the last line that says "End Sub", so you will end up with this:
Code:
Private Sub Workbook_Open ()
End Sub
Paste the text of your macro in between the two lines above.
Save your workbook, close it, and when you reopen it, it will run this macro automatically.
Hope this helps...
Eugene