Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box change event triggered from another file
Hi,
I'm using Excel 2007 and have a workbook that contains a number of ActiveX combo boxes on different sheets. When this workbook is open I've found that if I create a new workbook and enter a value to any cell in the new workbook the change events for each combo box on the active sheet in the original workbook are triggered! This results in various errors. However it doesn't happen if instead of creating a new workbook I open an existing one. I guess I'm going to have to add code to the combo box change events to check that the active workbook is the original workbook and exit if not. However this shouldn't be necessary. Has anybody come across this behaviour before and if so found any better way of preventing it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is this Worksheet Change Event triggered? | Excel Programming | |||
ComboBox Change event triggered incorrectly? | Excel Programming | |||
event triggered by cell format change? | Excel Programming | |||
Change event triggered by a named range | Excel Programming | |||
Help - Change Event triggered on File Save As | Excel Programming |