Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Receiving font error depwife Excel Discussion (Misc queries) 2 July 20th 07 02:34 PM
Renamed tab .xls3 receiving a error but can't fix TB Excel Worksheet Functions 2 July 31st 06 04:38 AM
How to use solver to schedule part time and full time workforce? The Ooz Excel Discussion (Misc queries) 0 August 18th 05 06:53 AM
Trying to open a file and receiving this error. John J. Excel Discussion (Misc queries) 1 March 4th 05 07:04 PM
How do I set up payroll for 1 full time and 1 part time employee? QuickBooks new user New Users to Excel 1 December 28th 04 10:48 PM


All times are GMT +1. The time now is 12:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"