Allow users to edit rangers
 

I currently have a worksheet that has locked & un-locked cells. At present
anyone can edit the un-locked cells.

What I am wanting to do is allow certain people to only edit certain
un-locked cells. I have tried to do this by using toolsprotectionallow
users to edit rangers, but it doesn't seem to work.

Can anyone help.

Cheers

Allow users to edit rangers
 

That feature is only available in versions 2003 (?) and later. If the WB is
opened on an older system, the setting will be ignored.
But assuming the user has a compatible version, what does "it doesn't seem
to work." mean ?
Not applied, errors, something else ?
Do you have to Protect the worksheet for these setting to come into effect ?

NickHK

"TheRook" ...
I currently have a worksheet that has locked & un-locked cells. At present
anyone can edit the un-locked cells.

What I am wanting to do is allow certain people to only edit certain
un-locked cells. I have tried to do this by using toolsprotectionallow
users to edit rangers, but it doesn't seem to work.

Can anyone help.

Cheers

Allow users to edit rangers
 

"It doesn't seem to work" means:

I have set the rangers that need a password when for editing and I have set
permission for the rangers so certain people can edit without a password. I
have then protected the works sheet, but it still allows anyone to edit?

Thanks


"NickHK" wrote:

That feature is only available in versions 2003 (?) and later. If the WB is
opened on an older system, the setting will be ignored.
But assuming the user has a compatible version, what does "it doesn't seem
to work." mean ?
Not applied, errors, something else ?
Do you have to Protect the worksheet for these setting to come into effect ?

NickHK

"TheRook" ...
I currently have a worksheet that has locked & un-locked cells. At present
anyone can edit the un-locked cells.

What I am wanting to do is allow certain people to only edit certain
un-locked cells. I have tried to do this by using toolsprotectionallow
users to edit rangers, but it doesn't seem to work.

Can anyone help.

Cheers

Allow users to edit rangers
 

Which version of Excel do they have ?

NickHK

"TheRook" ...
"It doesn't seem to work" means:

I have set the rangers that need a password when for editing and I have
set
permission for the rangers so certain people can edit without a password.
I
have then protected the works sheet, but it still allows anyone to edit?

Thanks


"NickHK" wrote:

That feature is only available in versions 2003 (?) and later. If the WB
is
opened on an older system, the setting will be ignored.
But assuming the user has a compatible version, what does "it doesn't
seem
to work." mean ?
Not applied, errors, something else ?
Do you have to Protect the worksheet for these setting to come into
effect ?

NickHK

"TheRook" ...

I currently have a worksheet that has locked & un-locked cells. At
present
anyone can edit the un-locked cells.

What I am wanting to do is allow certain people to only edit certain
un-locked cells. I have tried to do this by using
toolsprotectionallow
users to edit rangers, but it doesn't seem to work.

Can anyone help.

Cheers

Allow users to edit rangers
 

2003


"NickHK" wrote:

Which version of Excel do they have ?

NickHK

"TheRook" ...
"It doesn't seem to work" means:

I have set the rangers that need a password when for editing and I have
set
permission for the rangers so certain people can edit without a password.
I
have then protected the works sheet, but it still allows anyone to edit?

Thanks


"NickHK" wrote:

That feature is only available in versions 2003 (?) and later. If the WB
is
opened on an older system, the setting will be ignored.
But assuming the user has a compatible version, what does "it doesn't
seem
to work." mean ?
Not applied, errors, something else ?
Do you have to Protect the worksheet for these setting to come into
effect ?

NickHK

"TheRook" ...

I currently have a worksheet that has locked & un-locked cells. At
present
anyone can edit the un-locked cells.

What I am wanting to do is allow certain people to only edit certain
un-locked cells. I have tried to do this by using
toolsprotectionallow
users to edit rangers, but it doesn't seem to work.

Can anyone help.

Cheers