I don't know the 'why', but I seem to have gotten around it by adding an error trapper:
On Error GoTo HandleError
(code, code, code)
HandleError:
If Err.Number = "80004005" Then
cnCh5.Cancel
MsgBox "Error 80004005 thrown and trapped."
End If
Oddly, my MsgBox doesn't pop on this one...but at least the stupid error is gotten around. I had lots of trouble getting
Etc, based on Ms. Gosnell's p71, etc
|