Worksheet_Calculate Event is also triggered in another Excel workbook?
Posted on 2003-02-22
I hope someone can help me with the following problem:
I have written a Worksheet_Calculate Event for a particular worksheet in a particular workbook. I assumed that this event will only be triggered in that particular worksheet and in that particular workbook. But it seems that this event is also triggerd when I switch to another Excel workbook that I have open, and change a cell overthere. I don't want this, and I don't understand why he is doing that. Please help.