Solved

Disable CTRL-F11

Posted on 2011-02-11
10
314 Views
Last Modified: 2012-05-11
Hallo,

How can i disable the CTRL-F9?

tx
0
Comment
Question by:sonmic
  • 3
  • 3
  • 2
  • +1
10 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34874172
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
 

Author Comment

by:sonmic
ID: 34874216
I selected only Excel. Probably i did something wrong!
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34874228
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34874250
No problem.  The question Wizard can add zones that it might think you want.
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34874251
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
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 34874412
What are you actually trying to disable? The title says Ctrl+f11 but the question Ctrl+f9?
0
 

Accepted Solution

by:
sonmic earned 0 total points
ID: 34877915
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
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34906585
sonmic: I was waiting for you to clarify what Rorya asked in ID: 34874412????

Sid
0
 

Author Closing Comment

by:sonmic
ID: 34941294
Found it myself
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question