View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pm[_2_] pm[_2_] is offline
external usenet poster
 
Posts: 44
Default 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...