Workbook won't run - Missing Reference?

[AlexanderBB]

I have an xlsm file created in Office 2010 and have copied it to a 2nd machine running Office 2007

On attempting to run a macro it reported a Missing reference "Mircosoft Windows Common Controls 6.0 (SP6) and that it wants MSCOMCTL.OCX in C:\Windows\Sytem32.
I have copied it there but it still shows MISSING in Tools - References.
Shouldn't the "MISSING" part go away ?
If I ignore that and run code (which opens an ADODB Connection) it shows "Can't Find Project Or Library" on adOpenStatic in the line

rx.Open sql, cnn, sql, adOpenStatic, adLockReadOnly

If I try Debug-Compile it again reports "Can't Find Project Or Library" this time on line

Private Sub ListView1_ColumnClick(ByVal ColumnHeader As MSComctlLib.ColumnHeader)

I'm a bit lost sorting this. Can anyone help ? All works fine in Office 2010

 

[AlexanderBB]

I have it sorted. Needed to add the listview control (again?) From Additional Controls, than drag it onto the Form. It had gone.
Anyone know why? I also had a combo box on one of the worksheets and that seems to be bung, had to REM out code that referenced it.