Jay,

Events can be disabled in excel by use of Application.EnableEvents

You must ALWAYS remember to enable events when you have finished.

I normally do it like this ...

Application.EnableEvents = False
Your update code
Application.EnableEvents = True

and
dont forget to put in an error trap that has
Application.EnableEvents = True included.


I would imagine that this code would be placed in your Clear_Glass_Dat
macro

--
Kiera

Born ignorant and still perfecting the ar
-----------------------------------------------------------------------
Kieran's Profile: http://www.excelforum.com/member.php...nfo&userid=124
View this thread: http://www.excelforum.com/showthread.php?threadid=27144