The answer to both questions is yes.
By default, individual cells are set to "Locked", but this only comes
into force when the worksheet is actually protected. So, you need to
unlock the cells that you want to allow users to change, and to do this
you need to highlight them, then go to Format | Cells | Protection
(tab) and unclick Locked. Then you need to select Tools | Protection |
Protect Sheet and you have the option of password-protection (you will
have to enter it twice, but choose something memorable).
If users try to edit a locked cell they will be told that they can't,
but they will be able to edit an unlocked cell. They can't change
formats or column widths, and will not be able to change the name of
the sheet.
Hope this helps.
Pete
Peo Sjoblom - 24 Jan 2006 02:47 GMT
And if they can go online and use a search engine they can find a password
crack, anyone who uses Excel to store sensitive material is beyond naive

Signature
Regards,
Peo Sjoblom
Portland, Oregon
> The answer to both questions is yes.
>
[quoted text clipped - 14 lines]
>
> Pete
Gord Dibben - 24 Jan 2006 05:03 GMT
>and will not be able to change the name of
>the sheet.
Sheet protection alone will not prevent changing the sheet name.
Workbook Protection must be enabled to prevent sheet name changes.
Gord Dibben MS Excel MVP
>The answer to both questions is yes.
>
[quoted text clipped - 14 lines]
>
>Pete