Nick

The applications reside on the users' machines, so each user will have to
open the workbook that contains the application level event code. The best
way to handle this is to create an add-in and have all the users install it.
Then it will be available whenever they are running Excel. It doesn't have
to be an add-in, but it will be easier to distribute if it is.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"nickg420 " wrote in message
...
I've written a macro that's triggered by an the Workbook_Open
Application Level Event that I want to run when any workbook on my
server is opened by one of our network users.

The only problem is will this work for all users on my network?
Secondly where do I open the workbook in which Application Level Macro
is written in order for the application level events to fire?

Any help is greatly appreciated.


---
Message posted from http://www.ExcelForum.com/