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.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=553547