workbook calculate
 

hello

how can i run module when F9 pressed (-manual calculation)

in workbooks code:

Private Sub Workbook_Calculate()
Application.ScreenUpdating = False
Application.EnableEvents = False

Run Oblicz()

Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub

but it doesn't work...