Dear All,

I tried to subclass activex Excel worksheet within container
and this worked, BUT when I add it to the form, and try to fill up some excel values (design time) values are lost after form is saved/closed.

If I add plain ActiveX to the form then excel values are saved normally.

My next idea was to try to subclass activex without parent container
and then realised that I don't know how to do it. Aldough help states that activex can be subclassed I just simply don't know how to do it.

My Goal is to add few properties and methods to excel activex,
but then when add it and use it in the form - to also keep excel values entered at design time.

Any help is greatly appreciated.
TIA

Any