I try and avoid using the calc event for just this reason.

You could put something like this at the top of your event code

if activeworkbook.name = thisworkbook.name then
do your stuff
Else
do nothing
end if/ end sub

That will effectively turn your code off whenever the workbook it is in
is not the active one.

Cheers
Simon
Excel development website: www.codematic.net


Mark Driscol wrote:
I have a workbook "A" that uses the worksheet_calculate event in a
sheet. Working in other workbooks triggers the event from time to
time, and I'd like to be able to modify the event code to detect that
calculation was not triggered by working in "A" and exit.

Is this possible?

Thanks.

Mark