Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheets and Events
I have a workbook that has multiple worksheets - all sharing the same code in
the workbook, worksheets, module, and class module. When I process events on the first worksheet everthing works correctly. When I move to the other worksheets, everything works fine. When I move back to the first worksheet again, the events repeat themselves multiple times depending on the number of other worksheets I activated. For example, I go to the second worksheet and back to the first worksheet, the events run 2 times instead of 1 time. I go to the third worksheet and back to the first worksheet, the events run 3 times instead of 1 time. Anyone have thoughts on why would occur and how I could stop it. I control EnableEvents religiously throughout the code to stop the duplication of events. And it works for everything except when I'm switching from one of the other sheets back to the first sheet. Thanks Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheets events | Excel Programming | |||
how to compare times of events btwn worksheets | Excel Worksheet Functions | |||
How do i create a set of worksheets indvidual events to a master | Excel Discussion (Misc queries) | |||
Any mouse events for Worksheets? | Excel Programming | |||
How to trap KeyDown Events For Worksheets ? | Excel Programming |