Recalculation problems (VBA)

[pecosvil]

I have a project which at the very beginning sets calculation to Manual.
I also have a spreadsheet "Loans" that has an Event subroutine that calculates certain range whenever it is activated

Option Explicit
Private Sub Worksheet_Activate()
    Worksheets("Loan_Information").Rows(4).Calculate
End Sub

The problem I found is that whenever that range is recalculated, it automatically calls one UDF that is in another module and that is not even used in the range to be calculated. As you can imagine, that slows down the spreadsheet. To be more precise, I searched in Row(4) and couldn't find the problematic UDF.

Any ideas?
Thanks!

 

[Warship]

try:

Private Sub Worksheet_Activate()
    Application.EnableEvents = False
    Worksheets("Loan_Information").Rows(4).Calculate
    Application.EnableEvents = True
End Sub