You could limit it programmatically by responding to the user's selection.

Alternatively, I find DTPicker (Microsoft Date and Time Picker Control
in MSCOMCT2.OCX - you should have it) to be a nice date selection
control. It looks a lot neater than the calendar control and has MinDate
and MaxDate properties you can set.

HTH,
Gareth

jennifer wrote:
Is there a way to limit the calendar control to go from a specific date to a
specific end date?

For example, I have the control that comes up when a cell is selected but
need the calendar to be limited from Sep 1 2005 through Dec 31 2006 (only
those dates available for choice).

Any input would be appreciated! Thank you!