Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default 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
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
ACTIVE X CONTROL? Jase Excel Discussion (Misc queries) 1 May 9th 08 12:49 AM
Copy Paste Wierdness Rich[_5_] Excel Discussion (Misc queries) 1 May 8th 08 11:56 PM
Difference between a Forms Control verus Active-X Control funGT350 Excel Discussion (Misc queries) 6 May 6th 08 11:20 PM
Application.Max wierdness David Excel Programming 9 April 1st 05 03:07 AM
Tool Tip Text for Form control/ Active-X control Freddie[_2_] Excel Programming 0 October 19th 04 04:14 AM


All times are GMT +1. The time now is 12:08 AM.

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

About Us

"It's about Microsoft Excel"