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