Application Level Events Question

[nickg420]

I've written a macro that's triggered by an the Workbook_Ope
Application Level Event that I want to run when any workbook on m
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 Macr
is written in order for the application level events to fire?

Any help is greatly appreciated

 

[Dick Kusleika]

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.

 

[nickg420]

I was thiniking add in too the only problem would be that this macr
password protects each sheet of the workbook when it opens. So the onl
problem with that is when it is neccessary to edit a workbook they can
because as soon as it's opened by Excel it's password protected.

Is there some way to limit the Application Level Events to a specifi
folder of workbooks, i.e. if it's not opened from a certain path the
don't trigger the events. Could this be done with a simple I
statement? Any Help would be greatly Appreciated!

N

 

[Dick Kusleika]

NG

Is there some way to limit the Application Level Events to a specific
folder of workbooks, i.e. if it's not opened from a certain path then
don't trigger the events. Could this be done with a simple IF
statement? Any Help would be greatly Appreciated!

Yes, a simple If could do that.

If Wb.Path = "\\Server\c" Then
'Do stuff
End If

Wb is the argument to the Workbook_Open application level event.