How to disengage the F9 key

How to disengage the F9 key - Workbook_Open?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arturo - 16 May 2005 18:30 GMT

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

Reply to this Message

Tom Ogilvy - 16 May 2005 18:49 GMT

Look at excel vba help for the onkey function.

Signature

Regards,
Tom Ogilvy

> This preps the file as desired:
>
[quoted text clipped - 6 lines]
> Thank you,
> Arturo

Reply to this Message

Arturo - 16 May 2005 19:02 GMT

Thank you once again Tom...

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

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

> Look at excel vba help for the onkey function.
>
[quoted text clipped - 8 lines]
> > Thank you,
> > Arturo

Reply to this Message

SKRS - 21 Feb 2006 14:10 GMT

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

> Thank you once again Tom...
>
[quoted text clipped - 18 lines]
> > > Thank you,
> > > Arturo

Reply to this Message

SKRS - 21 Feb 2006 14:10 GMT

but where from testOFF/testON are invoked??

> Thank you once again Tom...
>
[quoted text clipped - 18 lines]
> > > Thank you,
> > > Arturo

Reply to this Message