If you are only concerned about the F9 key then you could disable F9 :

Private Sub Worksheet_Activate()
Application.OnKey "{F9}", ""
End Sub

Joerg

"roman99" wrote in message
...
How to propect a worksheet from recalculation by F9?
--
thx