>>I can then delete and modity whatever, no problem, I want
That part is expected. This does not protect a sheet from editing. Use
Tools, Protection, Protect Sheet for that.
>> and save it right on top of the original!
That's not what should happen or what happens to me. After I click Read
Only to open the file it says "[Read-Only]" in the worksheet window's
caption. And if I try to save it I cannot overwrite the original. I have
to use another name or another location.

Signature
Jim
>I have tried saving an xls sheet under a different name using a password to
>stop others from changing the contents but I can't seem to get it to work.
[quoted text clipped - 18 lines]
>
> What am I doing wrong, please?
John Vanini - 13 Oct 2007 19:00 GMT
That's brilliant! It works beautifully! I don't understand why the other
system didn't work as that is what it seemed to imply - but it really
doesn't matter.
Thanks a lot, Jim, I can now password protect my spreadsheet and I'm very
grateful.
John
> <snip>
> Use Tools, Protection, Protect Sheet for that.
><snip> Jim
Gord Dibben - 13 Oct 2007 19:23 GMT
Just note that Excel's internal password protection is very weak and passwords
easily cracked.
Gord Dibben MS Excel MVP
>That's brilliant! It works beautifully! I don't understand why the other
>system didn't work as that is what it seemed to imply - but it really
[quoted text clipped - 8 lines]
>> Use Tools, Protection, Protect Sheet for that.
>><snip> Jim
John Vanini - 14 Oct 2007 19:07 GMT
Oh dear, I didn't know that. I have produced a census in Excel, and wanted
to put it on the Internet but, obviously, I don't want anyone changing any
details.
I shall have to look for some other way.
Thanks to all for your help,
> Just note that Excel's internal password protection is very weak and
> passwords
> easily cracked.
>
> Gord Dibben MS Excel MVP
JE McGimpsey - 13 Oct 2007 20:16 GMT
Be aware that XL's protection is worth it's weight in tissue paper for
true security:
http://www.mcgimpsey.com/excel/removepwords.html
> Thanks a lot, Jim, I can now password protect my spreadsheet and I'm very
> grateful.