Add any activex control to toolbar?

[sebastienm]

Hi,
Main requirement: I am looking for a solution that would work with XL 2000
and above.

1. Is there a way to add any kind of activex control (eg: a treeview
control, or even my own custom activex control) to a toolbar with Excel.
Can it be done through a COM-Addin?

2. And what about these 'toolbars'[?] you can see in the Visual Studio .Net
IDE, the ones that you can dock on the sides; they show as a tab, and when
moving over they pop-up; when leaving the poped-up form/toolbar, they hide
and only show as tabs; you can also pin them so they stop hiding when leaving
them.
Any way to use these ones in Excel?
I have made a useform that approximately simulates the same behaviors,
but it 's too far from perfect.

3. I haven't read much about it but it seems like MS Visual Studio Tools For
Office could help, but: 1) i am not sure 2) it only works with XL2003 and
above, am i right?

Thank you,
Sébastien

 

[Stephen Bullen]

Unfortunately, the answers are:
1) No. While it is possible to get a custom ActiveX control on to a toolbar,
it can't be sized and doesn't have any idea of where it is (so can't do
anything meaningful).
2) No. Excel doesn't provide a window docking mechanism that we can hook into.
3) i) No. VSTO doesn't help here ii) Yes, VSTO only works with Office 2003
Professional.
--
Regards

Stephen Bullen
Take your Excel development to the highest levels
with "Professional Excel Development",
www.oaltd.co.uk/ProExcelDev

 

[sebastienm]

Thanks Stephen. Now that i know the answer is 'Not Possible', I can finally
stop searching.

Regards,
Sébastien