My problem is I have some value in the first row

suppose A1 has value NAME
B1 has value ADDRESS
C1 has value PHONE

I want to write a VB code which tells .. If i try to change the
value in these cells then there should be a message telling " these
cells are non editable" the the old values like NAME should be retained
in that cell

PLz help me

Why not protect the sheet with these 3 cells locked.

First select all cells and unlock them (CellsProtection and uncheck the
Locked box)
Select A1:C1, and lock them
Then protect the sheet (ToolsProtectWorksheet)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Gull" wrote in message
oups.com...
My problem is I have some value in the first row

suppose A1 has value NAME
B1 has value ADDRESS
C1 has value PHONE

I want to write a VB code which tells .. If i try to change the
value in these cells then there should be a message telling " these
cells are non editable" the the old values like NAME should be retained
in that cell

PLz help me

Why don't you protect those cells.

This is one option of how you can do it:

To unlock all cells, select all cells in the worksheet and
FORMAT CELLS - PROTECTION - Uncheck LOCKED.

Then select the cells that you want protected and FORMAT -CELLS-
PROTECTION - Check LOCKED

Then TOOLS - PROTECTION
I'd uncheck SELECT LOCKED CELLS.
If there are other things that your users need to be able to do, make
sure you allow it on this sheet.

"Gull" wrote in message
oups.com...
My problem is I have some value in the first row

suppose A1 has value NAME
B1 has value ADDRESS
C1 has value PHONE

I want to write a VB code which tells .. If i try to change the
value in these cells then there should be a message telling " these
cells are non editable" the the old values like NAME should be retained
in that cell

PLz help me

I have asimilar problem,

I don't want user to be able to change the cell - but they can be allowed to
delete the row... UI sm using Excel 2000 -- is this possible?

wAyne_

"Barb Reinhardt" wrote:

Why don't you protect those cells.

This is one option of how you can do it:

To unlock all cells, select all cells in the worksheet and
FORMAT CELLS - PROTECTION - Uncheck LOCKED.

Then select the cells that you want protected and FORMAT -CELLS-
PROTECTION - Check LOCKED

Then TOOLS - PROTECTION
I'd uncheck SELECT LOCKED CELLS.
If there are other things that your users need to be able to do, make
sure you allow it on this sheet.

"Gull" wrote in message
oups.com...
My problem is I have some value in the first row

suppose A1 has value NAME
B1 has value ADDRESS
C1 has value PHONE

I want to write a VB code which tells .. If i try to change the
value in these cells then there should be a message telling " these
cells are non editable" the the old values like NAME should be retained
in that cell

PLz help me