lock cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John R - 02 May 2008 22:54 GMT

Can you lock individual cells whereby it takes a different password to unlock
each individually locked cell?

Reply to this Message

Gord Dibben - 02 May 2008 23:19 GMT

Tools>Protection>Allow Users to Edit Ranges.

Each range which can be a single cell can have its own password.

Gord Dibben MS Excel MVP

>Can you lock individual cells whereby it takes a different password to unlock
>each individually locked cell?

Reply to this Message

Dave - 02 May 2008 23:47 GMT

Hi Gordon,
Jumping in...
I have XL2000 - don't seem to have the 'Allow Users to Edit Ranges' in my
protection options. Am I missing something, or is that a feature of later
versions?
Regards - Dave.

> Tools>Protection>Allow Users to Edit Ranges.
>
[quoted text clipped - 4 lines]
> >Can you lock individual cells whereby it takes a different password to unlock
> >each individually locked cell?

Reply to this Message

Gord Dibben - 02 May 2008 23:56 GMT

I skipped XL2000 when I went from 97 to 2002 so can't speak to that question but
probably came in with 2002 version along with some other new features for
protecting worksheets.

Keep eye on this, someone will drop in with an answer.

Gord

>Hi Gordon,
>Jumping in...
[quoted text clipped - 11 lines]
>> >Can you lock individual cells whereby it takes a different password to unlock
>> >each individually locked cell?

Reply to this Message

Dave Peterson - 02 May 2008 23:59 GMT

Added in xl2002.

> Hi Gordon,
> Jumping in...
[quoted text clipped - 11 lines]
> > >Can you lock individual cells whereby it takes a different password to unlock
> > >each individually locked cell?

Signature

Dave Peterson

Reply to this Message

Dave - 03 May 2008 00:10 GMT

Hi Gordon & Dave,
Thanks for the info.
Regards - Dave.

Reply to this Message