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