Hi,

I tried to check the option of Data Validation but it was going
disabled/grayed out after enabling the macros.Still I cannot find a solution
for the below issue.It is working for the current date for eg if it 04/01/08
it will go in with the DATE ENTRY but if you give 31/12/07 or any of the
future date like 08/01/08 etc it won,t go in the template and will show the
******** DATE ENTRY ERROR****** window.Please help me in finding a solution
for this as quickly as possible.

Regards
Binu Gopal



I could be way off base here, but it sounds to me like Data Validation. Try
looking at Data Validation, and see if anything there strikes you as
unusual or unnecessary.

Here is some documentation for DV:
http://www.contextures.com/xlDataVal01.html#DataVal01

Regards,
Ryan--


--
RyGuy


"Binu Gopal" wrote:

Hi ,

When I am trying to enter a date previous to the current date and any future
date in an excel template which is having macros running.For eg If i give a
current date the template will work and will go into the worksheet.But when I
tried to give any previous date or any future date it is giving a "DATE ENTRY
ERROR" and the template is not working at all.

I tried to check the short date in the control panel and made the date
settings as dd/mm/yy format and tried for the template.Still it is allowing
only for the entry for the present date.No user can enter any previous date
and any future on the template.xls.

Please suggest the solutions as early as possible.This is very URGENT for me

Thanks and Regards