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