I think this one will definitely take some imagination.

In an Excel VBA from, when you click on the DTPicker control it
displays a month calendar appears and you are able to select a date. I
need to figure out how to expand the calendar programatically, i.e.,
without having to click on it. Ideally, the control would have
included a "Expand" method but no such luck. The control does have an
hWnd property so perhaps there is a Win32 API approach that might
work??

Incidentally, using a slicker, third-party calendar control is not an
option because there will be no opportunity to install any new controls
on the user's machines.

Thanks in advance,

Bob