Range Protection
 

Hi everyone,
Difficult question but easy to someone who knows.
I know how to protect a sheet and how to lock/unlock cells so they can be
edited once the sheet is protected but...
How do you protect a range of cells so they can be edited using a password
whilst still leaving the rest of the sheet available for input?
It baffles me.
Can any one help...........please.
Many thanks.

Range Protection
 

If you're using xl2002+, you can use:
tools|protection|Allow users to edit ranges.

Phil Gilligan wrote:

Hi everyone,
Difficult question but easy to someone who knows.
I know how to protect a sheet and how to lock/unlock cells so they can be
edited once the sheet is protected but...
How do you protect a range of cells so they can be edited using a password
whilst still leaving the rest of the sheet available for input?
It baffles me.
Can any one help...........please.
Many thanks.

--

Dave Peterson