Re: Restrict cell deletion

Tech-Archive recommends: Fix windows errors by optimizing your registry


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
***,
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
<starguy.29p6qn_1150801804.2266@xxxxxxxxxxxxxxxxxxxxx> wrote:


I only want to restrict cell(s) deletion from anywhere in the ***,
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?action=getinfo&userid=32434
View this thread: http://www.excelforum.com/showthread.php?threadid=553547

.

Quantcast