View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_3_] Dick Kusleika[_3_] is offline
external usenet poster
 
Posts: 599
Default Application Level Events Question

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.

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