Hi Peter,

The person having the problems has VB6 installed, but not SP6.
She has exactly the same version as my .ocx file, but not sure about the
dll.
I could no wiser either from making a wrapper of a container for the RTB.
I read the article you mentioned but the resolution in there was a bit vague
and sparse to say the least.
Still, it might be the way to go, although it all runs fine in my Excel
2003.

RBS


"Peter T" <peter_t@discussions wrote in message
...
Hi Bart,

Like you I also have vb6 and the Microsoft Rich Textbox Control 6.0 (SP6).

All works fine if I create my own, or receive as a vba from someone else,
in
my W98 Xl2000.

However I assume users would simply require to be installed the current
versions of
richtx32.ocx (the RTB "wrapper" for) and riched20.dll
(subject the various security issues)

Another link which overall I read as a rather surprising state of affairs.

http://support.microsoft.com/default...b;en-us;838010

This also makes mention of creating a "container" control to host the RTB
control.

Hmm, a container for the wrapper, sounds like Russian dolls!

Regards,
Peter T



"RB Smissaert" wrote in message
...
Hi Peter,

Well, I definitely get it in 2000 and not in 2002 or 2003, athough I had
the
warning once after I upgraded my XL 2002 to 2003, but never after.
My helpfile writer however gets it in 2003 and has major problems with
this,
to the extent that it crashes Excel and
the add-in can't be used. This is on Windows 2000. She admits though that
her system may need a cleanup.

Maybe this newsgroup thread shows the solution to these major problems:

http://groups.google.co.uk/group/mic...oper.vba/brows
e_thread/thread/3ef04a2f2a8cef1e/76252635e022bb41?lnk=st&q=excel+2003+richte
xtbox&rnum=6&hl=en#76252635e022bb41

I am not sure if it is relevant that I have VB6 on my system and the
control
seem to have been updated with SP6:
Microsoft Rich Textbox Control 6.0 (SP6)

The control itself works perfect and it is very nice indeed to colour
format
the SQL.

RBS

"Peter T" <peter_t@discussions wrote in message
...
Hi Bart,

I think the security warning is in xl2003, not xl2000 and would indeed
apply
to a RTB.


http://support.microsoft.com/default...20&Product=xlw

No idea about wrapping in another control.

Regards,
Peter T


"RB Smissaert" wrote in message
...
I am using a RichTextBox control (Microsoft Rich Textbox Control 6.0
(SP6))
on a VBA Userform in Excel.
There is no problem in Excel 2002 and 2003, but in Excel 2000 there is
a
security warning:
This application is about to initialize ActiveX controls that might be
unsafe. If you trust the source of this file, select OK and the
controls
will be initialized using your current workspace settings.
It is not a major problem, but I understand this warning can be
avoided
if
the RichText control is somehow wrapped in another control. Can't find
though how this should be done.
I need the RichTextBox for colour formatting of SQL keywords.
Any suggestions for a workaround of this are appreciated.

RBS