ExcelBanter - BLOCK CELLS FROM BEING EDITED

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - BLOCK CELLS FROM BEING EDITED (https://www.excelbanter.com/excel-discussion-misc-queries/193005-block-cells-being-edited.html)

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

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