hi,

i would like to know if there is a way to protect a sheet so that most of
the cells are protected, but column d is unprotected. i am asking this
because for some reason on worksheet selection change, if i click somewhere
else in the sheet, or even select a range other than what is in the A_range
defined name range, i get a "type mismatch" error message. here is the code
i have:
if not intersect(target, range("A_range")) is nothing and
range(target.address).value < "" then
dim...

thanks in advance,
geebee