The question is moot, because Application.EnableEvents only pertains to
events associated with Excel objects and their events - Workbook, Worksheet,
Application. Events for the MSForms 2.0 controls are not affected by this
setting. I have never seen the behavior you describe. I think you would
have to examine what would cause a change in the combobox that would cause
the event to fire. Are there some formulas being recalculated that change
the rowsource of the comobobox. If so, you may need to populate the
combobox with code and remove the rowsource.

Regards,
Tom Ogilvy


"Bart" wrote in message
...
Hi Patrick,
I have the feeling that once a message is answered, no
other user tends to look at the question. So please be
careful when answering question and read the text
completely.
When your answer is of no use to me I then have no other
way to attract someone elses attention than by repsoting
my problem.

As I stated, the copying of the sheet is manually (the
user of my sheet just copies the sheet in the way I
discribed). So where would I put
the 'Application.EnableEvents' = False code if (as I said)
I have no knowledge of a worksheet_copy event.

Thanks

PS: could you reply to this message? Because I even have
the feeling that even authors of the thread don't worry
about following up.

-----Original Message-----
set
Application.EnableEvents = False
befor eyou do the copying
then reset to True when you want your events to work again

Patrick Molloy
Microsoft Excel MVP


-----Original Message-----
Hello,
when i copy an excel97 worksheet (with ActiveX
comboboxes
on them) manually (rightmouseclick + ctrl +
drag&relaese)
the code for the combobox click event is called.
I'd like to prevent that from happening.

1. The combobox_change event is also called.
2. I found no Worksheet_copy event where I could
intercept
the combobox event (or it's just not documented?)

Thanks
.

.