Block the F8 function key

[zelarra]

Hi guys. I need your help.

In the workbook_open event I have added the following to avoid opening Powershell:

Application.OnKey "%{F12}", ""

Now, on the other hand, I want to prevent the F8 function key being activated so that the user cannot start the selection with the keyboard. I have tried the following, but I can't make it work:

Application.OnKey "{F8}", ""

Can anyone tell me what I am doing wrong?

Thank you so much.

 

[zelarra]

Nobody can help me?

 

[Logit]

Paste in the THISWORKBOOK module :

Option Explicit

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Application.OnKey "{F11}"
End Sub

Private Sub Workbook_Open()
    Application.OnKey "{F11}", ""
End Sub

 

[zelarra]

Solved

Private Sub Workbook_Open()

    Application.OnKey "{F18}", "DisableF8"

End Sub

In a module:

Private Sub DisableF8()

Exit sub

End Sub