Mike, you can name it auto_open or put your code in the workbook open event

Sub Auto_Open()

'your code here

End Sub

or in thisworkbook


Private Sub Workbook_Open()

'your code here

End Sub



--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **


"OceansideDJ" wrote in message
...
How can I rename a macro in Excel 2000 to run automatically when the
spreadsheet opens?

Thanks,

Mike