If you've set up Locked/Unlocked status on individual cells, and then if
you've set protection for the sheet, the protected status should go with the
workbook.

About the only way I can think of that this might not work is if you have
protection being turned on in code and the macro security setting on the
other machine(s) is set to HIGH, which would prevent the code from running
and setting the protected state of the sheet.

Make sure you are setting the workSHEET's protected status and not the
workBOOK's. They are two different operations.

I'm wondering if there might be something involved here with different
versions of Excel, but again, I've not heard of this being an issue. But you
might find out if the other people have the same version of Excel that you
have.

"Frederick" wrote:

I have successfully created a worksheet with protection of all cells except
where user input is required. It works fine on my PC, but when I give the
file to someone else to use on their own PC the protection is not working.
Any ideas how I can retain the original protection for unknown users working
on their own PCs?