schedule/appointment book calendar control questions

[gregfibersoft]

I am working on a schedule book for scheduling daily routes for three vans. want to incorporate a calendar that stays visible that displays the currenty month and highlights the current day. Trying to figure out how to set it up so that when you click on a day on the calendar; that days spreadsheet becomes active. I want this to be my primary navigation method. Any help would be greatly appreciated. Thanks!!!!!!

 

[sweater_vests_rock]

hi greg.

martin green has put together a nice site explaining the ActiveX calendar control. some modifications on his example could do just what you want.

cheers. ben.