How to disengage the F9 key - Workbook_Open?

[Guest]

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

 

[Tom Ogilvy]

Look at excel vba help for the onkey function.

 

[Guest]

Thank you once again Tom...

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

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

 

[Guest]

hey thr,
where do you invoked testOFF/ON from??

i've somethin like below

Private Sub Workbook_Open()
MsgBox "open"
Application.OnKey "{~}", "EnterKey"
End Sub
Sub EnterKey()
MsgBox "enter key"
Call ActiveCell.Offset(ActiveSheet.Target.Row + 1,
ActiveSheet.Target.Column)
End Sub

in the above code, enterkey is not being invoked. where should the
application.onKey assignment be done.

appreciate your inputs.

thanks

 

[Guest]

but where from testOFF/testON are invoked??

Thank you once again Tom...

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

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