Input this into the Thisworkbook code mould

Private Sub Workbook_Open()

End Sub

and add your code to it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kanye" wrote in message
...
I've located the Thisworkbook code module, but see nothing about
Workbook-Open event. Where do I look for this?

"kanye" wrote:

I'd like to set a macro so that when the file is opened, it
automatically runs.