Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SheetSelectionChange Target size Limitation? | Excel Programming |