Kieran,

Thanks so much for your help! Your suggestion works perfectly, and I have
learned something new.

Jay


"Kieran" wrote in message
...

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_Data
macro.


--
Kieran

Born ignorant and still perfecting the art
------------------------------------------------------------------------
Kieran's Profile:
http://www.excelforum.com/member.php...fo&userid=1247
View this thread: http://www.excelforum.com/showthread...hreadid=271446