View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
roadkill
 
Posts: n/a
Default Events won't Disable!

I have 2 combo boxes on the same sheet and both have Combobox_Change() event
code associated with them. This code resides in the sheet object (same
sheet) and both macros call other routines in a module in this same
spreadsheet file. When one of these events fires, I want to inhibit the
other from firing while the first's code is executing. I've tried using
Application.EnableEvents = False, but it's just ignored. Does anyone know
why this would be?

Thanks,
Will