Use Application.EnableEvents = False to stop events from firing.
Set it back to true at the appropriate place in your code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"short_n_curly"

wrote in message
news:short_n_curly.1rau2l_1119899158.6547@excelfor um-nospam.com...

is it possible to stop the selection change event procedure
from being
triggered from within a worksheet change event code
i.e i have an event by slection that will begin the start of
event by
change but keeps looping when triggered
if the change would stop the selection code once activated it
will
prevent any looping

hope this makes sense i would imagine it be something similar
to
either
exit private sub worksheet_selectionchange
or
end provate sub worksheet_selectionchange
however neither of these codes work

please help me thanks


--
short_n_curly
------------------------------------------------------------------------
short_n_curly's Profile:
http://www.excelforum.com/member.php...o&userid=21576
View this thread:
http://www.excelforum.com/showthread...hreadid=382587