I have worksheet_change event code stored in an addin.
The addin's routines are accessed via a series of menu items.

The event code is designed to track changes in Col B while
the user creates their workbook, or later returns to modify it.

Is there a way via a menu item to enable/disable the event
code, please?

So, the user would open a workbook and the event code
would be disabled. If the user wanted, they would select the
menu item to enable the event code (for that workbook only),
but when that workbook was closed/saved, then the event
code would be disabled by default.

Any help much appreciated.

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.535 / Virus Database: 330 - Release Date: 01/11/2003