I get your drift now.

Perhaps this might suit. For 2002 and 2003

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

FormatCellsProtection. Clear the locked button.

ToolsProtectionProtect sheet.

Check your options for selecting locked and unlocked cells, row and column
deletion and insertion and OK.

Click on a cell and the "delete" option is not available although you can clear
contents.

Click on a row header and delete is available for entire row.


Gord

On Wed, 21 Jun 2006 03:37:09 -0500, starguy
wrote:


infact I have row wise data in sheets if any of cell is deleted all data
is messed up but if complete row is deleted nothing happened wrong.
I explain it by example:
col A.....col B........col C.....col D
Name....Father....Gender...Address

if any cell of col A is deleted, cells below come up and relate to the
right information which is not true. same is the case with cells of col
B, C, and D that if any single cell or some cells are deleted all
information is messed up but if complete row is deleted then its okay.
I hope this will explain my problem to make you understand.

Gord Dibben Wrote:
Just curious, but if you will not allow cells deletion anywhere on the
sheet,
how can you allow deletion of rows and columns?

Deletion of rows and columns will delete the cells contained therein.

Perhaps there is some other explanation/description of what you want?


Gord Dibben MS Excel MVP

On Tue, 20 Jun 2006 06:05:33 -0500, starguy
wrote:


I only want to restrict cell(s) deletion from anywhere in the sheet,
all
other options should be allowed i-e row and column deletion of
insertion
etc.