How to give access to certain cells in the protected worksheet ?

[Guest]

Suppose I protected the whole worksheet (Tools > Protection > Protect Sheet).
How do I give access only to certain cells so that users could make changes
in them, but not in the rest area of the worksheet ? Thanks!

 

[GRM via OfficeKB.com]

Suppose I protected the whole worksheet (Tools > Protection > Protect Sheet).
How do I give access only to certain cells so that users could make changes
in them, but not in the rest area of the worksheet ? Thanks!

format, Cells, Protect

untick locked

 

[Guest]

Thanks! One more question - there is a hidden worksheet in the workbook,
protected by password. Every time the user is entering the data into unlocked
cells of the unprotected worksheet, Excel is asking for a password. How do I
stop it ? Thanks!

 

[GRM via OfficeKB.com]

The whole idea of hiding AND protecting a spreadsheet is to protect access.
So either
1 Unhide the sheet or
2 Hide but don't protect the sheet or
3 Give the user the password

Thanks! One more question - there is a hidden worksheet in the workbook,
protected by password. Every time the user is entering the data into unlocked
cells of the unprotected worksheet, Excel is asking for a password. How do I
stop it ? Thanks!
[quoted text clipped - 3 lines]

untick locked

 

[Gord Dibben]

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then Format>Cells>Protection. Uncheck "locked"
and OK.

Select the cells you wish to lock and Format>Cells>Protection. Check "locked"
and OK.

Now Tools>Protection>Protect Sheet. This is mandatory.

You can set a password to unprotect. These can easily be broken in Excel but
will keep your formulas from being accidentally overwritten.

NOTE the options available in xl2002 and 2003 when you hit Protect Sheet


Gord Dibben Excel MVP

Suppose I protected the whole worksheet (Tools > Protection > Protect Sheet).
How do I give access only to certain cells so that users could make changes
in them, but not in the rest area of the worksheet ? Thanks!

Gord Dibben MS Excel MVP