Date/Time/Calendar Control to work in multi Excel platforms (2003/2007/2010)?

[shell_l_d]

Need a Date/Time/Calendar Control to work in multi Excel platforms (2003/2007/2010) please...

So... I have several spreadsheets created using Excel 2007 with 'Calendar Control 12.0' controls in them. It wont work in Excel 2010 as that control was removed from Office 2010!!!

Now... I also have a different spreadsheet created in Excel 2010 with 'Microsoft Date and Time Picker 6.0 (SP6)' controls in it. It wont work in Excel 2007 as that control doesn't exist in Office 2007!!!

I want to have a multi-compatible spreadsheet (that at least works with Excel 2007 & 2010 & probably also 2003) with a date/time/calendar control in it but dont really want to have to instruct each person who may use it to install some add-in to their Excel.

What options do I have please?

Further to:
http://social.msdn.microsoft.com/Fo...be5-5d7f-4fb2-ae16-1438e0e736a4?prof=required

http://www.mrexcel.com/forum/showthread.php?t=70813&page=2

 

[marts]

Code extracts from my post #5 above shows

"1) Download mscomct2.cab from http://activex.microsoft.com/controls/vb6/MSCOMCT2.CAB" _
"2) Unzip/extract mscomct2.cab (.ocx & .inf)" _
"3) Copy extracted files to relevant directory as administrator (click continue if prompted for admin permission)" _
" c:\windows\system\ = Windows 95, 98, or ME" _
" c:\WINNT\system32\ = Windows NT or 2000" _
" c:\windows\system32\ = Windows XP or 7" _
" c:\windows\sysWOW64\ = Windows 7 64bit" _
"4) Close & re-open spreadsheet." _

I got a similar or maybe related issue here from my thread... Unfortunately the instructions above only fix when I am embedding the DTPicker on VBA form environment. I have still have the problem when inserting it on a worksheet.