Which workbook caused calculation

  • Thread starter Thread starter Mark Driscol
  • Start date Start date
M

Mark Driscol

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
 
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
Click to expand...

One way to do that is to set a public boolean variable (like bWSA maybe) to
true whenever Worksheet A is activated, then reset it to false when A is
deactivated. Then check the value of bWSA when the worksheet_calculate
event is triggered, like

If bWSA = true then
call yoursub
End if

Something like that. The many experts here may have simpler, or more
complex, solutions.
 
One way to do that is to set a public boolean variable (like bWSA maybe) to
true whenever Worksheet A is activated, then reset it to false when A is
deactivated. Then check the value of bWSA when the worksheet_calculate
event is triggered, like

If bWSA = true then
call yoursub
End if

Something like that. The many experts here may have simpler, or more
complex, solutions.
Click to expand...

Thank you, I'll try that.

Mark
 
you could code the ThisWorkbook event

Private Sub Workbook_SheetCalculate(ByVal Sh As Object)

End Sub
 
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
 
Back
Top