Group:  Microsoft Excel ยป microsoft.public.excel.templates
Thread: Restrict dates entered in date formatted cells

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Restrict dates entered in date formatted cells
"ladyhawke" <noesgard[ at ]gmail.com> 16.08.2006 13:23:44
I would like to restrict dates entered to a certain month for each
sheet (e.g only dates i january for the sheet named Jan).

How can this be done? Macro/directly or something else?

It would be nice if you could just enter the date and the the month and
year were automatically filled in (month according to selected sheet
and year according to current year, though it should be possible to
change year if needed)

Do I make sense?

Regards,
Ladyhawke

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net