How to give access to certain cells in the protected worksheet ?
By default all cells are locked when the sheet is protected.
Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked"
and OK.
Select the cells you wish to lock and FormatCellsProtection. Check "locked"
and OK.
Now ToolsProtectionProtect 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
On Wed, 18 Oct 2006 06:33:02 -0700, fbagirov
wrote:
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
|