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 |
"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 |
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 |
All times are GMT +1. The time now is 06:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com