Thanks - Your suggestion of the problem being in ThisWorkbook or the
worksheet code module pointed me in the right direction and I resolved it! I
hadn't destroyed the collections variable in the ThisWorkbook event that was
being used in the sheet module to create the object events when the worksheet
was activated. When I set it to nothing before looping to re-create my
events, it resolved the problem.

Steve

"JLGWhiz" wrote:

As a further comment, it appears from your description that the relevant
code would be in either the worksheet code module or the ThisWorkbook code
module and is either related to the Worksheet_Change or the
WorksheetSelection_Change events.



"sarndt" wrote in message
...
If you mean between the worksheets, no I don't. Each worksheet should
stand
independent of the rest.

Steve

--------

"sarndt" wrote:

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


.