How to auto hide - Date and time picker control 6.0

**junada0** · 01-20-2010, 06:39 PM

Is there a way to auto hide ]Date and time picker control 6.0, so that the calender only appears when a cell is selected.

I would like to have the option to click on a cell say A1 and many other selected cells and a calender then open up (with todays date) and allow me to select another date.

I can get the calender to link to a cell but the calender is always stays visible in full month view, would like it to auto hide when moving away from cell A1 etc.

Many thanks for any help.

**Leith Ross** · 01-20-2010, 10:14 PM

Hello ,

To make this work, requires code be placed in each DTPicker_CloseUp() event and each worksheet's Worksheet_SelectionChange event that has one or more DTPickers. Here is the code.

DTPicker CloseUp Event Code
This code must be added to each DTPicker. Be sure to change the DTPicker name to match the new control when adding the code.

Please Login or Register  to view this content.

Worksheet Selection Change Event Code

Please Login or Register  to view this content.

**junada0** · 01-21-2010, 03:33 AM

Hello,

Thanks for your reply, but on reflection and having had problems with date & time picker on other pc's with excel 2007, I believe that the Calender control 11.0 / 12.0 may be a better option.
Could you offer any help on this function, where again i would like the calendar to appear when a cell is selected and disappear when a date is entered.

Many Thanks