View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default Suppressing events

application.enableevents = false

BIG NOTE be very sure to reenable events with application.enableevents =
true or else events will not function AT ALL.

"rci" wrote:

Hi all...


I am changing the value of a checkbox in code... and I need to suppress the
click event when doing so. How might I do this?

In other words, changing the value of a checkbox triggers the .click event,
and I need to prevent this...

Thanks!

M