Problem with an Excel Sheet

Spammeh · 5 Mar 2009 at 16:16

If someone can help with this problem it would be wonderful.

One of our members of staff have been emailed an excel document which works fine bar some MS date picker controls (I THINK thats what they are). The control isn't displayed and instead the cell is filled with a red cross. I have been trying to find a resolution for this to make the excel worksheet work fine but have been unable yet. Upto now I've done the following:

Ensured that the macro security is set to low (for the time being)
Installed the MS VBA 6.0 controls

Does anyone know how to fix this? If so, I would be most pleased.

http://img26.imageshack.us/my.php?image=datepickerprob.jpg

Spammeh · 6 Mar 2009 at 11:37

I've tested it in both excel 2003 and 2007, and haven't had any more luck

Spammeh · 12 Mar 2009 at 10:34

I've checked this and it says: "MISSING: Microsoft Windows Common Controls-2 6.0 (SP4).

Just for reference I'm running MS Office 2003 Standard SP3. Any takers?

Spammeh · 12 Mar 2009 at 10:41

Ok, I've found the right file (MSCOMCT2.OCX) and copied that into c:\windows\system32 which has stopped the above error message showing but I'm still have the same problem.

Any ideas?

Spammeh · 12 Mar 2009 at 14:34

the DTpicker control is contained within the Windows Common controls which it see's fine so unless i'm missing something I don't think we need to install any other addons :S