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.
--
SteveB

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" wrote in message
...
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.
--
SteveB

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


"Peter T" wrote:

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" wrote in message
...
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.
--
SteveB

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" wrote:

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" wrote in message
...
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.
--
SteveB

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" wrote in message
...
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" wrote:

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" wrote in message
...
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.
--
SteveB

Ok, i looked through the entire list and dont see anything about a datagrid
on it. Is getting the upgrade that was posted on the support link the way to
go to get the datagrid?

"Peter T" wrote:

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" wrote in message
...
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" wrote:

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" wrote in message
...
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.
--
SteveB





.

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


"Mr. GetRight" wrote in message
...
Ok, i looked through the entire list and dont see anything about a
datagrid
on it. Is getting the upgrade that was posted on the support link the way
to
go to get the datagrid?

"Peter T" wrote:

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" wrote in message
...
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" wrote:

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" wrote in message
...
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.
--
SteveB





.