Auto protection of cells

  • Thread starter Thread starter Jambar
  • Start date Start date
J

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

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

Regards,

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

Thanks anyway

-VJ
 
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
 
Back
Top