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

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

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

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


"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

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