but where from testOFF/testON are invoked??


"Arturo" wrote:

Thank you once again Tom...

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

Sub testON()
Application.OnKey "{F9}"
End Sub


"Tom Ogilvy" wrote:

Look at excel vba help for the onkey function.

--
Regards,
Tom Ogilvy



"Arturo" wrote in message
...
This preps the file as desired:

Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub

Where would I find the syntax to disengage the F9 key too?

Thank you,
Arturo