Prev: Print all open files
Next: moved macros to new book, now not working
From: sarndt on 26 Apr 2010 23:46
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" <sarndt(a)discussions.microsoft.com> wrote in message
> news:1FA28DFA-54D6-41B9-B9EC-7AFACA596171(a)microsoft.com...
> > 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
>
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Print all open files
Next: moved macros to new book, now not working