Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a project that contains a number of forms and when i try to
show the last one in normal run mode i get the error: run-time error ‘-2147417848 (80010108) Automation error The object invoked has disconnected from its clients Originally it also locked out the keyboard also. I used the appspro project cleaner like someone else was told for a similar problem and now it doesnt lock out the keyboard but the form wont show. If i try to just show the form in a different sub i get the 424 object required error (i think its 424). The other forms in the project will show during normal running but get the 424 error trying to run them on their own. The other advice they received was to rebuild it in a new book. Does this mean from scratch like i have to retype the main code? or can i copy and paste the code to say word reuse it and just rebuild the forms from scratch? Also as i have messed with this i noticed somthing strange. I have a module where i keep useful code snippets to copy instead of having to retype them everytime and i also keep basic forms that i can just import and rename for the same purpose. Those forms were giving me the same 424 error when i tested them after the main project. I wondered if maybe they were "broken" since i made the project forms from them. So I closed excel (it locked up doing so had to ctrl alt delete out) and then the basic forms worked fine when i reopend and tried again. I would appreciate any input on this matter thank you john |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) | Excel Programming | |||
Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
Loading Userform Errors 1004 | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions |