On Tue, 16 Sep 2003 at 00:27:19, Ron de Bruin (Ron de Bruin
) wrote:
You can use a cell on your worksheet for example with
Yes or No in it to turn it off.

You can use this as first line then in the change event

If Range("A1").Value = "No" Then Exit Sub

I've just remembered :- Application.EnableEvents = False is what I need
--
Mike