lock cells
 

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

lock cells
 

ToolsProtectionAllow Users to Edit Ranges.

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


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 14:54:00 -0700, John R
wrote:

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

lock cells
 

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.

"Gord Dibben" wrote:

ToolsProtectionAllow Users to Edit Ranges.

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


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 14:54:00 -0700, John R
wrote:

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

lock cells
 

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

On Fri, 2 May 2008 15:47:01 -0700, Dave wrote:

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.

"Gord Dibben" wrote:

ToolsProtectionAllow Users to Edit Ranges.

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


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 14:54:00 -0700, John R
wrote:

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

lock cells
 

Added in xl2002.



Dave wrote:

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.

"Gord Dibben" wrote:

ToolsProtectionAllow Users to Edit Ranges.

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


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 14:54:00 -0700, John R
wrote:

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



--

Dave Peterson

lock cells
 

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