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?

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?

Thanks for your reply, I'm glad I'm not the only one surprised by this
problem. I am protecting the sheet using a password under the tools command.
I have now tried the file on a few more PCs, sometimes the correct cells are
protected and sometimes not. Like you I have concluded that maybe its
something to do with different excell operating formats, but not had time to
experiment further with that yet to see how the problem can be fixed. I am
more experianced with PowerPoint, and was expecting the excel protection
facility to behave like the password protection in PowerPoint, which it
clearly doesn't. Any further thoughts would be appreciated.

"JLatham" wrote:

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?

I really don't have much more to offer. Excel's protection is more of a
format protection than anything approaching security.

But why the same workbook is acting differently on different machines is a
new one on me, but generally I'm using a specific version targeting client's
systems which will generally have only one version of Excel on them. Wish I
had something more for you - only thing I can recommend is take note of both
the operating system version and the Excel version on each machine and see if
there is a patter as to which it works properly with and which it doesn't.

"Frederick" wrote:

Thanks for your reply, I'm glad I'm not the only one surprised by this
problem. I am protecting the sheet using a password under the tools command.
I have now tried the file on a few more PCs, sometimes the correct cells are
protected and sometimes not. Like you I have concluded that maybe its
something to do with different excell operating formats, but not had time to
experiment further with that yet to see how the problem can be fixed. I am
more experianced with PowerPoint, and was expecting the excel protection
facility to behave like the password protection in PowerPoint, which it
clearly doesn't. Any further thoughts would be appreciated.

"JLatham" wrote:

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?