Calendar Control 9.0

Hey guys. I have set up a Calendar pick (Calendar Control 9.0) when anyone clicks on a date formatted cell. But when I resize the calendar, save, close, then reopen, it shrinks, but the font stays the same, so it basically squishes the fonts so you can't read it. Is there a way to fix this, or make sure the size stays constant? Here is my code to pop up the calendar

ActiveSheet.Calendar1.Visible = True
 With ActiveCell.Next
    ActiveSheet.Calendar1.Left = .Left
    ActiveSheet.Calendar1.Top = .Top
 End With
 End

Thanks in advance!

Re: Calendar Control 9.0

I have seen that, but I wanted something simpler that I know will work on everyones computer which is Excel 2003, with low memory useage, so the Calendar Control seemed the most simple, or at least did.

Re: Calendar Control 9.0

The memory is not Ram related, it is just speed related. The workbook I created is up to 5 meg file, that is run from the server, so we are trying to keep it as low as possible. After thinking about it though, I may try it since I have to insert the CC9 object in everysheet anyway, it may be a wash. I will try it and let you know how it works. Thanks!!