Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EnableEvents | Excel Programming | |||
EnableEvents doesn't work | Excel Programming | |||
Application.EnableEvents | Excel Programming | |||
Application.EnableEvents help | Excel Programming | |||
application.EnableEvents | Excel Discussion (Misc queries) |