Problem with VB going outside the Sub to do other things.
The following is part of an risk analysis, when VB
hits Sensitivity.Range("Sens_area").Clear it
goes to a module that have lots of functions that has
nothing to do with the risk calculations. I have tried
Application.EnableEvents = False and then turning it on
after without success.

Using Application.Calculation = xlCalculationManual works
until I need to start the calculations again
Application.Calculation = xlCalculationAutomatic then it
does the same thing it goes to the module with the
functions.

How can you stop VB to go outside the sub during its
execution?

Thanks,

Urban


Private Sub RiskButton()

Application.ScreenUpdating = False

' Starts risk calculations when risk button is pressed.


'This part calculates different scenario that have
different values of the 3 parameters
'(IRR, Year, NPV) to perform the Risk analysis

Sensitivity.Unprotect Password:=PWD
Sensitivity.Range("Sens_area").Clear
Sensitivity.Range("Sens_RiskNum").Clear

Sensitivity.Range("VarTab").EntireRow.Hidden =
False