Re: Restrict cell deletion

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

I get your drift now.

Perhaps this might suit. For 2002 and 2003

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

Format>Cells>Protection. Clear the locked button.

Tools>Protection>Protect ***.

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
<starguy.29qugo_1150879207.2987@xxxxxxxxxxxxxxxxxxxxx> 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
***,
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.

.

Quantcast