Because the checkbox is not part of the Excel application object, so it
doesn't apply. It is either part of the Office forms object.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Stefi" wrote in message
...
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