Disable CTRL-F11

Hallo,

How can i disable the CTRL-F9?

tx
sonmicAsked:
Who is Participating?
 
sonmicConnect With a Mentor Author Commented:
Tx for your answers but it didn't fit.
Here i was looking for:

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

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Application.OnKey "^{F11}"
0
 
slightwv (䄆 Netminder) Commented:
This was cross posted in Oracle.  If this is not Oracle related I would like to remove that Zone.

Disable it from what app or in what way?
0
 
sonmicAuthor Commented:
I selected only Excel. Probably i did something wrong!
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
SiddharthRoutCommented:
Paste this in the  Workbook WindowResize event.

Private Sub Workbook_WindowResize(ByVal Wn As Window)
    If ActiveWindow.WindowState = -4140 Then ActiveWindow.WindowState = -4137
    If ActiveWindow.WindowState = -4143 Then ActiveWindow.WindowState = -4137
End Sub

Open in new window


Sid
0
 
slightwv (䄆 Netminder) Commented:
No problem.  The question Wizard can add zones that it might think you want.
0
 
SiddharthRoutCommented:
Or better still try this

Private Sub Workbook_WindowResize(ByVal Wn As Window)
    If ActiveWindow.WindowState <> -4137 Then _
    ActiveWindow.WindowState = -4137
End Sub

Open in new window


Sid
0
 
Rory ArchibaldCommented:
What are you actually trying to disable? The title says Ctrl+f11 but the question Ctrl+f9?
0
 
SiddharthRoutCommented:
sonmic: I was waiting for you to clarify what Rorya asked in ID: 34874412????

Sid
0
 
sonmicAuthor Commented:
Found it myself
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.