Check whether in any of the macros you have set
Application.EnableEvents to False and then missed to reverse it to True


If this post helps click Yes
---------------
Jacob Skaria


"kirkm" wrote:

Is there any known condition in Excel which
disables every macro, or sheet click/double click event etc etc ?

I get this a lot and can't figure out what causes it.

The fix is to close and re-open Excel and everything works again.
But it would be nice to prevent it happening at all.

Thanks - Kirk