Posted to microsoft.public.excel.programming

Stefi

external usenet poster

Posts: 2,646

EnableEvents doesn't work

Hi All,

I have a checkbox with a CheckBox_Click event. In some cases I want to
change the value of its linked cell (to FALSE) through VBA, and in these
cases I don't want to run CheckBox_Click event code. I set
Application.EnableEvents to FALSE before changing the linked cell value, but
event code is still executed. How can I avoid it?

Thanks,
Stefi

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Application.EnableEvents	DCPan	Excel Worksheet Functions	3	October 18th 08 05:46 AM
EnableEvents BeforeClose	Stefi	Excel Programming	2	November 16th 05 09:22 AM
application.EnableEvents	nc	Excel Discussion (Misc queries)	1	September 28th 05 04:00 PM
EnableEvents=False doesn't work? or does it?	Intellihome[_30_]	Excel Programming	0	June 25th 05 05:29 PM
application.enableEvents	jeffP	Excel Programming	1	August 1st 04 03:12 PM

All times are GMT +1. The time now is 06:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us