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.