Thread: On Change Event
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default On Change Event

This will happen if worksheet events are left dis-abled.

Many Event macros disable events, do some processing, and then re-enable
them before exiting. If the routine exits prematurally, the dis-able may be
left in effect.
--
Gary's Student


"Jeanne Conroy" wrote:

Hi Group:

I created a macro to pop up a message box under certain conditions using the
Workbook_Change property of a worksheet. However sometimes it seems to stop
working. What could cause this?

JJ