Hi
first: the event will only work for the workbook in which
it's resides. So
AFAIK no chance to trigger this event
from a different workbook
Seconds: Your error could be that you have disabled
application.enableevents in the second workbook. This is
an application setting and would also affect your first
workbook. so you may check the event procedures in
workbook 2 for a missing
application.enableevents = true
statement
-----Original Message-----
I am trying to use the SheetSelectionChange event in a
workbook. I have a workbook(WB1) with no modules in it but
the following under ThisWorkbook:
Private Sub Workbook_SheetSelectionChange(ByVal Sh As
Object, ByVal Target As Range)
MsgBox "Workbook_SheetSelectionChange"
End Sub
When I open it everything is fine. Then I open another
workbook(WB2) with lots of modules and event triggers. I
work with this WB2 for awhile and then the event in the
first WB1 will no longer fire off.
What I really want is for the
Workbook_SheetSelectionChange to fire off in WB2 but that
hasn't happened yet. What am i resetting to get this
behavior?
---
Steph
.