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
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