Hi Kate

Sub Auto_open()
MsgBox "Hi"
End Sub

Must be in a normal module
If you use a Auto_open macro then this wil not run if you open the file with a macro


Private Sub Workbook_Open()
Msgbox "Workbook Opened"
End Sub

Must be in the Thisworkbook module


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kate" wrote in message ...
Hi,

I have a macro already built into the spreadsheet, but I
need to add a code that would make the macro run when the
spreadsheet is initially opened by the user.

Any ideas???

Thanks.
Kate