Microsoft Date Time Picker not available in Excel 2010??

[Jeffrey Lebowski]

Hi,


Last week I was working with Excel 2007, and I had created a workbook that used the Microsoft Date & Time Picker a number of times. I have distributed this workbook to a number of colleagues...and have since upgraded to Excel 2010.


Now, when I open the workbook, a big ugly red X appears where this calendar control should be. I cannot add it in like I did before because this control is missing from 2010. Can someone help me incorporate this type of functionality using Excel 2010 without having to write code? I would prefer to not have to save it as a macro-enabled workbook.


Thanks for your help.

 

[SirJB7]

Hi, Jeffrey Lebowski!

This question has been posed several times at this forums, tried using the built-search in?

Regards!

 

[NARAYANK991]

Hi Jeff ,


Try the suggestions given here :


http://social.msdn.microsoft.com/Forums/office/en-US/c7ccebe5-5d7f-4fb2-ae16-1438e0e736a4/excel-date-time-picker-calendar-controls-multi-compatible-


Narayan