We have several Excel spreadsheets that were created and protected in
Excel 97 and 2000. Many of the wks are forms used by personnel for
submitting expense reports, planning travel, etc. Recently we migrated
all of our users to Office XP (Excel 2002).

Now when a user opens one of the spreadsheets created and protected in
Excel 97/2000 in Excel 2002, enters data and then saves and closes it,
when they re-open it all of the previously selected cells are
un-selectable by the user.

If the user just opens one of the wks and does not make any changes and
then saves it, when they reopen it the cells are not user select locked.
The cells are only user select locking after data is entered and the
file is saved.

Once the cells are user select locked, if the user takes the file back
to a system still running office 2000 and opens it, the user can select
and edit the cells contents.

Also if we open the cell select locked file in 2002 and save it as a
Excel 95 file and then reopen it in 2002, the users is then once again
able to enter data.

We fixed some of the wks by un-protecting them and then resetting the
protections. However, this is not an option for all of the files as we
do not control them.

We understand that Excel 2002 provides the developer with much more
granularity in the protection options than previous versions. However,
one would think that as cell user select locking was not an option in
the earlier versions, Excel 2002 would not be enable this by default
when working with a protected XLS file created in a previous version.


Does any by have an explanation and hopefully a solution for this does
not require us to rework all of the files?

Thanks


--
TWilson
------------------------------------------------------------------------
TWilson's Profile: http://www.excelforum.com/member.php...o&userid=25939
View this thread: http://www.excelforum.com/showthread...hreadid=393164