Home |
Search |
Today's Posts |
#1
|
|||
|
|||
open vb
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 |
#2
|
|||
|
|||
"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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel | |||
Cannot open Excel attachment from e-mail when Excel is already ope | Excel Discussion (Misc queries) | |||
When I open excel document it always ask if I want to open it in . | Excel Discussion (Misc queries) | |||
Excel Files Won't Open From Shortcut | Excel Discussion (Misc queries) | |||
Cannot open a file that Excel says is open | Excel Discussion (Misc queries) |