J
JayDee
I locked cells in an excel spreadsheet and used a password to protect the
sheet.
However, when the users copy the file to their computer, add data, and
return the file or if the user has a different version of Excel (97 vs
97-2003 compatible), the file loses the password requirement. Once the user
copies the file, they can select "unprotect" the sheet without entering the
password.
Is there a way to maintain the password if the file is copied to another
computer or version of Excel?
sheet.
However, when the users copy the file to their computer, add data, and
return the file or if the user has a different version of Excel (97 vs
97-2003 compatible), the file loses the password requirement. Once the user
copies the file, they can select "unprotect" the sheet without entering the
password.
Is there a way to maintain the password if the file is copied to another
computer or version of Excel?