open vb

[Guest]

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.

 

[Guest]

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.

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

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

 

[Bob Phillips]

Put the code in Workbook_Open event.