Receiving run-time error only part of the time

A

adam_kroger

When the Sub is called from a workboox event I receive the following
error:
Run-time error '-2147417848(80010108)':
Automation error
The object invoked has disconnected from its clients

However, when I execute the Sub from inside the VB Editor, it
functions correctly. Why?

The triggering event is a ComboBox_Change (without dropdown). and the
Sub routine sets data validation for a named range in the workbook.
The full code can be posted if needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation error '-2147417848 (80010108)' excel 2007 0
VBA - Run time error when modules combined??? 7
Run-time error ‘-2147417848(8001 2
Run-time error when copying entire row! 5
Run-time error? 2
Run-time Error '-2147417848 (80010108)' 1
Problem with excel macro - getting automation error 3
Run-time error '-2147417848 (80010108) 1

Top