Hi.

Thanks to Sandy and Gord

It works!

Next issue: if somebody wants to change a cell all they have to do is click
on unprotect worksheet. Am I correct?

Is there any way to prevent this?
--
vze2mss6


"Gord Dibben" wrote:

I see that now Sandy.

Too quick on the trigger.

Removal as you have shown is best.


Gord

On Mon, 20 Aug 2007 22:37:25 +0100, "Sandy Mann"
wrote:

Interesting that you should suggest that Gord,

If Intersect(Range("A:IV"), Target) Is Nothing

where else could it be?