I will have a think about the problem but on the general point of
distributing the spreadsheet I do have a concern.
I avoid using the calendar control because there used to be a problem
of compatability between the various calendar control versions and also
between the VBA and VB versions. I strongly suggest that you test this
out before commiting to using it.

regards,


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=505531