Auto protection of cells

[Jambar]

I have the Dates in Column A , I want to protect the cells in Cloumn
B , based on todays date .This needs to be done automatically w/o
going to format cells , protection . How to do that ?
I mean noone can make any entry to the date other than Today's date
- Vijay

 

[Guest]

Hi,

Try Data Validation.

Select Select cells then to get into data validation:-

xl2007 version: Data tab on ribbon->Data tools block->Data Validation

pre xl2007 versions: Menu item Data->Validation->

In allow field: Select Dates

Data field: Equal to

Uncheck Ignore blanks

In Formula field: =today()

Regards,

OssieMac

 

[Guest]

Correction:

You may or may not want to ignore blanks. Leave checked if you want to allow
blank cells.

Regards,

OsseiMac

 

[Jambar]

Unfortunately I have X/2000 and not X/2007, if you can suggest other
methods that will be helpful.

Thanks anyway

-VJ

 

[Guest]

Hi again,

I included the following in my reply:-

pre xl2007 versions: Menu item Data->Validation->

(the above includes xl2000 and I thought that xl2000 included data validation.

Regards,

OssieMac