T
Trip
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
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