protecting specific parts of my worksheet.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yaka - 19 Jun 2007 23:10 GMT

I made an attendance worksheet that has the first three columms tthat need
protection and the columns with formulas in that need protection but the rest
of the areas need to be available to add information. how do I lock or
protect just what I want protected and allow the other useres to do there
thing.

Needing your assistance thankfully

Reply to this Message

Gary''s Student - 20 Jun 2007 00:59 GMT

1. unprotect the sheet
2. unlock all cells
3. select the cells or rows or columns to be locked
4. Format > Cells... > Protection > Locked
5. protect the sheet

Signature

Gary''s Student - gsnu200731

> I made an attendance worksheet that has the first three columms tthat need
> protection and the columns with formulas in that need protection but the rest
[quoted text clipped - 3 lines]
>
> Needing your assistance thankfully

Reply to this Message

Gord Dibben - 20 Jun 2007 01:28 GMT

Yaka

By default, all cells are protected when sheet protection is enabled.

Hit CTRL + a(twice in 2003) to select all cells.

Format>Cells>Protection. Uncheck "locked" and OK out.

Select the cells you want protected and Format>Cells>Protection

Check "locked".

Tools>Protection>Protect Sheet. Note the options when protecting.

Supply a password and OK.

Excel's internal security is weak but this will prevent overwriting by accident.

Gord Dibben MS Excel MVP

>I made an attendance worksheet that has the first three columms tthat need
>protection and the columns with formulas in that need protection but the rest
[quoted text clipped - 3 lines]
>
>Needing your assistance thankfully

Reply to this Message