If you are doing this with a macro, as always, post your macro

--
Don Guillett
SalesAid Software

"Rebecca" wrote in message
...
Hi, again (sorry!). I have locked all columns except one (for editing),
and
I want to seach for something in one locked column and replace something
in
another (unlocked) column. But I keep getting an error message saying I
can't do this. Why? What I want to do is lock five columns (to prevent
loss
of data by accident) and replace items in the unlocked column. Frankly,
locking columns is somewhat more complicated than in Access. Could
someone
please explain how to do this? Thanks.