Is there any way to lock a Calendar control in such a way that someone could
only select a Thursday? Ideally the last Thursday of the month.

Wouldn't it be easier for all concerned if you put a list of last Thursday
dates in a named range and then use a data validation listbox that references
that range for date selection in the cell. It sure would save you a lot of
work.

--
Kevin Backmann


"Patrick Simonds" wrote:

Is there any way to lock a Calendar control in such a way that someone could
only select a Thursday? Ideally the last Thursday of the month.

I suppose you are right, but I like the idea of the Calendar control because
it presents a more finished look to what I am doing.


"Kevin B" wrote in message
...
Wouldn't it be easier for all concerned if you put a list of last Thursday
dates in a named range and then use a data validation listbox that
references
that range for date selection in the cell. It sure would save you a lot
of
work.

--
Kevin Backmann


"Patrick Simonds" wrote:

Is there any way to lock a Calendar control in such a way that someone
could
only select a Thursday? Ideally the last Thursday of the month.