| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
BLOCK CELLS FROM BEING EDITED
I have a spread sheet where I need block the values of certain cells from
being edited by my team. At the same time I would like them to have the rights to edit most of the other cells in the spread sheet. Could anyone throw some light on how we can do this. Prasad |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
BLOCK CELLS FROM BEING EDITED
By default all cells in a worksheet are locked when sheet protection is enabled.
It is up to you to decide which are to be locked or unlocked when the sheet is protected. FormatCellsProtection is where you would change the "locked" or "unlocked" status. Then ToolsProtectProtect Sheet. Gord Dibben MS Excel MVP On Sat, 28 Jun 2008 10:56:01 -0700, Prasad Gopinath wrote: I have a spread sheet where I need block the values of certain cells from being edited by my team. At the same time I would like them to have the rights to edit most of the other cells in the spread sheet. Could anyone throw some light on how we can do this. Prasad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding a block of cells | Excel Discussion (Misc queries) | |||
| how do I lock certain cells from getting edited | New Users to Excel | |||
| Custom functions not updating when dependant cells are edited | Excel Discussion (Misc queries) | |||
| Using validation to block cells | Excel Discussion (Misc queries) | |||
| copy a block of cells | Excel Discussion (Misc queries) | |||
Linear Mode
