Thread: open vb
View Single Post
  #2   Report Post  
bigwheel
 
Posts: n/a
Default

"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