A thought comes to mind. You say you want entry into that cell disabled.
Do you want to just disable it and not tell the user anything about why he
can't enter anything into that cell? Or do you want him to not be able to
enter anything into that cell AND tell him so and why when he tries to do
it? HTH Otto
"TimN" wrote in message
...
FIRST.... Let me say thanks for all the help I have received. I am new to
this position and new to VBA and nobody at the company knows it so You all
have been a life saver for me!!!

Here is the question:

Can I write code so than in the worksheet If cell D1 has the value of "Y",
and the user tries to enter data in E1, the cell (E1) would be disabled
from
any entries going in?

Thanks again!!!

TimN