Thread: VB CODE
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default VB CODE

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