Protection of a worksheet

[gregchilton]

Hi

I have two questions.

The first one: is it possible to protect certain parts and not the
whole worksheet and,
The second one: is it possible to prevent a person changing the name of
a worksheet.

Thanks

Greg

 

[Pete_UK]

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]

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

--
Regards,

Peo Sjoblom

Portland, Oregon

 

[Gord Dibben]

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