View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default Worksheets and Events

Do you want to share the event code? That is probably where the answer
lies.


"sarndt" wrote in message
...
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