I think you've got the wrong end of the stick here.

Read this site to get a proper understanding of events
http://www.cpearson.com/excel/events.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"cgaynor" wrote in message
...
Excel uses interrupts to send warning meaasages like the
one you mentioned. The EnableEvents command enables or
disables these interrups. This is also used to suppress
the "Do you want to replace this file" message when saving
an existing file in VBA. Try using this:

Application.EnableEvents = False ' turns interrupts OFF
.
[your code]
.
Application.EnableEvents = True ' turns interrupts back
ON

Be sure to set to reenable Events after executing your
code but before you leave the procedure or else you will
not receive any warning messages during the rest of your
Excel session.

Charlie