ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Receiving run-time error only part of the time (https://www.excelbanter.com/excel-discussion-misc-queries/153821-receiving-run-time-error-only-part-time.html)

[email protected]

Receiving run-time error only part of the time
 
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.



All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com