 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Excel 2000: allow users to edit ranges
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 >>Was this option not included in Excel 2000? No, it was new in Excel 2002. No way to add it to Excel 2000.  SignatureJim |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 [quoted text clipped - 9 lines] | | Mark That's what I was afraid of. I'll have to try and get him upgraded. Thanks. >>>Was this option not included in Excel 2000? > [quoted text clipped - 17 lines] > | > | Mark
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.