Incompatible "allow users to edit range" in earlier Excel versions

I have developed a protected workbook and sheets in Excel 2002 (to ensure the
integrity of formulas created therein), while enabling other users to edit
specific cells (with input variables). It has worked just fine for several
other users, unless the user has Excel 2000 - which seems to block their
ability to change ANY cell in the sheet. I'm told that I can save the file
in an earlier version format (which I have done), but before sending to the
user, I want to be sure that the sheets and workbook are still protected to
the extent that I initially intended. Any ideas? Thanks!

xl2002 was the first version that offered this type of protection.



PKnott wrote:
>
> I have developed a protected workbook and sheets in Excel 2002 (to ensure the
> integrity of formulas created therein), while enabling other users to edit
> specific cells (with input variables). It has worked just fine for several
> other users, unless the user has Excel 2000 - which seems to block their
> ability to change ANY cell in the sheet. I'm told that I can save the file
> in an earlier version format (which I have done), but before sending to the
> user, I want to be sure that the sheets and workbook are still protected to
> the extent that I initially intended. Any ideas? Thanks!

--

Dave Peterson