Auto protection of cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jambar - 30 Oct 2007 03:42 GMT

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

Reply to this Message

OssieMac - 30 Oct 2007 06:01 GMT

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

> 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

Reply to this Message

Jambar - 06 Nov 2007 05:42 GMT

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

Thanks anyway

-VJ

On Oct 30, 10:01 am, OssieMac <Ossie...@discussions.microsoft.com>
wrote:

> Hi,
>
[quoted text clipped - 25 lines]
>
> - Show quoted text -

Reply to this Message

OssieMac - 06 Nov 2007 07:09 GMT

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

> Unfortunately I have X/2000 and not X/2007, if you can suggest other
> methods that will be helpful.
[quoted text clipped - 34 lines]
> >
> > - Show quoted text -

Reply to this Message

OssieMac - 30 Oct 2007 06:04 GMT

Correction:

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

Regards,

OsseiMac

Reply to this Message

Rate this thread: