V
vha
Anyone run into this defect? I know it is related to unqualified objects.
"Automation Error - the object invoked has disconnected from its clients"
It occurs in a simple test of the sheet change event. If I delete a cell's
contents with the delete key in an unprotected section of a protected sheet,
I get this error and the Excel instance hangs. It only occurs if I flip
protection on and off.
Event code
Private Sub ssTest_SheetChange(ByVal Sh As OWC11.Worksheet, ByVal Target As
OWC11.Range)
Sh.Unprotect
MsgBox (Sh.Application.Name)
Sh.Protect
End Sub
"Automation Error - the object invoked has disconnected from its clients"
It occurs in a simple test of the sheet change event. If I delete a cell's
contents with the delete key in an unprotected section of a protected sheet,
I get this error and the Excel instance hangs. It only occurs if I flip
protection on and off.
Event code
Private Sub ssTest_SheetChange(ByVal Sh As OWC11.Worksheet, ByVal Target As
OWC11.Range)
Sh.Unprotect
MsgBox (Sh.Application.Name)
Sh.Protect
End Sub