Put the code in Workbook_Open event.

--
HTH

Bob Phillips

"bigwheel" wrote in message
...
"Yaasien Parker" wrote:

I'd like a macro to run when a specific file is opened. The file is on
our
server and will be accessed by different users on different machine - so
xlStart is out.

--
Yaasien Parker

Put your macro in the Microsoft Excel Object named ThisWorkbook something
like

Sub workbook_activate()
MsgBox "Hi Yaasien Parker"
End Sub