PDA

View Full Version : Calendar problem



machunt
04-29-2012, 05:44 AM
Hi,
I have a sheet where I do some critical analysis on a form in excel 2007.
Now I have used a calendar to insert date,
and I have used this line to show the current date by default on the calandar
Calendar1.Value = Now()

But is there a way to disable the selection of previous dates by default.

also place another button on the form, which when clicked will ask for a password that will unlock the calendar to select previous dates.

Please guide me,
Thanks,
Mac

machunt
05-01-2012, 07:42 PM
Any help...
Regards,
mac

Bob Phillips
05-02-2012, 12:33 AM
I am afraid I can't test what I am saying as I have 64 bit windows and so no calendar, but I would have thought that you cannot stop anyone from selecting on the calendar, so you would have to check after the value has been selected, and if already used, then reject that value and re-open the calendar.

If you post the workbook and give us details on how to work through the situation you want to manage, I can fire up another box that does have a calendar and test it.