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