Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Object invoked disconneted from its clients"
I have validation procedure in a selectionchange event that when activated
causes a Comboboxchange event which in turn causes a Selectionchange event and I get the subject error , when the validation procedure runs again. What I want to do is resume the selection change event where I left off, Not start a new one. Any one have suggestions? -- Glen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Object invoked disconneted from its clients"
GlenC,
Have you tried using Application.EnableEvents to turn events on and off? I can't tell if you want the Combo change event to fire or not, but if you don't it sounds like you could just set Application.EnableEvents = False at the start of your SelectionChange event code and back to True at the end of it. hth, Doug "GlenC" wrote in message ... I have validation procedure in a selectionchange event that when activated causes a Comboboxchange event which in turn causes a Selectionchange event and I get the subject error , when the validation procedure runs again. What I want to do is resume the selection change event where I left off, Not start a new one. Any one have suggestions? -- Glen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Object invoked disconnected from its clients. | Excel Programming | |||
Automation Error : The Object Invoked Has Disconnected From Its Clients !! | Excel Programming | |||
"Object disconnected from clients"?? | Excel Programming | |||
Automation Error: The Object Invoked Has Disconnected from Its Clients (Excel) | Excel Programming | |||
Automation Error: The Object Invoked Has Disconnected from Its Clients | Excel Programming |