Thread: EnableEvents
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default EnableEvents

Hi All,

I have a CheckBox1 with Sub CheckBox1_Click(). In a certain case I want to
change the value of linked cell of CheckBox1 through VBA and in this case
triggering Sub CheckBox1_Click() is not required. I tried
Application.EnableEvents = False, but it had no effect. I solved the problem
by setting/resetting a public variable, but I'd like to know the reason why
Application.EnableEvents = False is ineffective in such cases.

Thanks,
Stefi