Ah, I wasn't thinking of that. I'd assumed that one would *want* to fire
the _Calculate() event if cells were calculating based on a cell
reference, since the Calculate event code could be independent of the
_Change() macro. Especially since the _Calculate() macro runs before the
_Change() macro does, potentially acting on invalid data (e.g., if an
INDIRECT() references N5, the first _Calculate macro will operate while
that formula evaluates to #REF! if the sheet doesn't exist, or the wrong
sheet if a sheet with that name already exists).

Using the Application.EnableEvents = False makes sense, of course, if
you know that you don't want to run the _Calculate() macro,.

In article ,
"Frank Kabel" wrote:

AFAIK the calculate event gets fired if a formula is referencing this
changed sheet