Help - Run Macro on Calculate

  • Thread starter Thread starter DonW
  • Start date Start date
D

DonW

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
 
BlankPut codes into the SheetCalculate event of the module "ThisWorkbook"


Private Sub Workbook_SheetCalculate(ByVal Sh As Object)

End Sub
"DonW" <[email protected]> 撰寫於郵件 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
 
BlankThanks Eddy
Put codes into the SheetCalculate event of the module "ThisWorkbook"


Private Sub Workbook_SheetCalculate(ByVal Sh As Object)

End Sub
"DonW" <[email protected]> 撰寫於郵件 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
 
Back
Top