View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default 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