VB CODE

G

Gull

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
 
B

Bob Phillips

Why not protect the sheet with these 3 cells locked.

First select all cells and unlock them (Cells>Protection and uncheck the
Locked box)
Select A1:C1, and lock them
Then protect the sheet (Tools>Protect>Worksheet)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
B

Barb Reinhardt

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.
 
W

wAyne

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_
 
Top