Missing Control In Addin

[SteveB]

I was using a DataGrid to display an ADO recordset in on a form in an Excel
2003 Add-in. I upgraded to Excel 2007 and the Datagrid is now gone. When I
try to put a datagrid on the form, I get an error message. Does anyone know
way this happened and how to fix it.

 

[Peter T]

Add it to your Toolbox. Rt-click, Additional controls

If it doesn't work, "not trusted", see here

http://support.microsoft.com/kb/957924

Regards,
Peter T

 

[SteveB]

Thanks, Did get the "not trusted"; briefly read the referenced doc and it
looks very promising....

 

[Mr. GetRight]

I Have same issue but I cant seem to find "Rt-click" as one of the avaible
controls. I am using Excel 2007

 

[Peter T]

I shouldn't have said Rt-Click!

In 2007, Developer tab, Insert, ActiveX controls, click "More Controls" with
a toolbox icon on bottom right.

Regards,
Peter T

 

[Mr. GetRight]

Ok, i looked through the entire list and dont see anything about a datagrid

 

[Peter T]

First of all let me clear up how to access the controls, having given two
different ways -

Worksheet ActiveX:
In 2007, Developer tab, Insert, ActiveX controls, click "More Controls" with
a toolbox icon on bottom right.

In 97-2003, in the Control Toolbox toolbar, click "More Controls" with a
toolbox icon on bottom right.

VBE, Userform, all versions:
Activate a userform, normally the Toolbox window appears (if not do View,
Toolbox), rt-click over the Controls tab, Additional Controls.


Regarding your missing datagrid control, certainly download and install the
update via the link I referred you too. Even if you already have the latest
version reinstalling should ensure the controls are correctly registered.
You should be looking for "Microsoft Datagrid Controls 6.0 (SP6)..."

You might check version before and after: In your system folder (typically
System32 depending on OS) look for MSDatGrd.ocx, right-click and look at the
version tab, it should be 6.1.98.16 (as of date of this post).

Another thing you might need to do in 2007 is look at -
Excel Options, Trust Center, Trust Center Settings, ActiveX Settings

Regards,
Peter T