I think you have to close and reopen any workbook to enable/disable macros for
that workbook.

RICK wrote:

once disabled can it be re-enabled without closing down and re-opening the
workbook?

--

Dave Peterson