View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default SheetSelectionChange

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
.