Help - Run Macro on Calculate
 

BlankI have several workbooks with multiple sheets filled with formulas. At the same time, I also have a number of modules and sub procedures in my vba code.

Is there a method/procedure/function to automatically run a module/sub procedure when a user chooses "Calculate" or presses "F9" in a worksheet??

Thanks,
Don

Help - Run Macro on Calculate
 

BlankPut codes into the SheetCalculate event of the module "ThisWorkbook"


Private Sub Workbook_SheetCalculate(ByVal Sh As Object)

End Sub
"DonW" 撰寫於郵件 ...
I have several workbooks with multiple sheets filled with formulas. At the same time, I also have a number of modules and sub procedures in my vba code.

Is there a method/procedure/function to automatically run a module/sub procedure when a user chooses "Calculate" or presses "F9" in a worksheet??

Thanks,
Don

Help - Run Macro on Calculate
 

BlankThanks Eddy
"Eddy" wrote in message ...
Put codes into the SheetCalculate event of the module "ThisWorkbook"


Private Sub Workbook_SheetCalculate(ByVal Sh As Object)

End Sub
"DonW" 撰寫於郵件 ...
I have several workbooks with multiple sheets filled with formulas. At the same time, I also have a number of modules and sub procedures in my vba code.

Is there a method/procedure/function to automatically run a module/sub procedure when a user chooses "Calculate" or presses "F9" in a worksheet??

Thanks,
Don