Excel 2000: allow users to edit ranges

[Mark Christensen]

I have Excel 2002 SP3 but another user has 2000 SP3. I created a big
worksheet but only want him to be able to edit 1 column, so I used the Tools

Protection > Allow users to edit ranges and gave him access to that 1

column. When he opens it in 2000, he can not edit anything without first
removing the protection from the entire worksheet. When I go to his Tools >
Protection, he only has 3 options: protect sheet; protect workbook; protect
and share workbook. He has no allow users to edit ranges option. Was this
option not included in Excel 2000?

Is there an update or add in for 2000 so this will work? Thanks.

Mark

 

[Jim Rech]

Was this option not included in Excel 2000?

No, it was new in Excel 2002. No way to add it to Excel 2000.


--
Jim
|I have Excel 2002 SP3 but another user has 2000 SP3. I created a big
| worksheet but only want him to be able to edit 1 column, so I used the
Tools
| > Protection > Allow users to edit ranges and gave him access to that 1
| column. When he opens it in 2000, he can not edit anything without first
| removing the protection from the entire worksheet. When I go to his Tools| Protection, he only has 3 options: protect sheet; protect workbook;
protect
| and share workbook. He has no allow users to edit ranges option. Was this
| option not included in Excel 2000?
|
| Is there an update or add in for 2000 so this will work? Thanks.
|
| Mark
|
|

 

[Mark Christensen]

That's what I was afraid of. I'll have to try and get him upgraded. Thanks.