Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active X Control Wierdness...
Hello all,
I'm not sure what's happening. I have two differnt version of a workbook I have been building for quite a while. They are only one version increment apart - I have not made any major changes. In the older version, when it starts-up I get the "This applicaion is about to initialize an active-x control...." warning to which I say ok and everything works just dandy. The active x control is a rich text box residing in several forms. On the newer version I do not get the warning until I try to open a module in the VBA editor or tyr to save the workbook or launch a form with the rich text box, etc. Once the active x control is initialized any time I try to update a control via VBA Excel just completely shuts down and tries to "recover" my work. However, if I try to update a control via the Imediate Window I can do so without crashing Excel. This happens even if I "Reset" the execution of the code and then try to launch the workbook manually by executing ThisWorkbook_Open(). In fact, at this point I can not successfully launch the workbook because as soon as I try to update a control Excel shuts down. Here's more wierdness. After the active x control is initialized in both versions, if I step through the code line by line from ThisWorkbook_Open() everything executes exactly the same for both versions until I try to update a control. Then one proceeds no problem and the other crashes. Security is set the same in both cases and the OCX control is present in both versions' references and both point to the same .ocx file. Any thoughts guys?? Please help!! Thanks, Trip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ACTIVE X CONTROL? | Excel Discussion (Misc queries) | |||
Copy Paste Wierdness | Excel Discussion (Misc queries) | |||
Difference between a Forms Control verus Active-X Control | Excel Discussion (Misc queries) | |||
Application.Max wierdness | Excel Programming | |||
Tool Tip Text for Form control/ Active-X control | Excel Programming |