Solved

Disable CTRL-F11

Posted on 2011-02-11
10
309 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 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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
Comment Utility
I selected only Excel. Probably i did something wrong!
0
 
LVL 30

Expert Comment

by:SiddharthRout
Comment Utility
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
No problem.  The question Wizard can add zones that it might think you want.
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 30

Expert Comment

by:SiddharthRout
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
sonmic: I was waiting for you to clarify what Rorya asked in ID: 34874412????

Sid
0
 

Author Closing Comment

by:sonmic
Comment Utility
Found it myself
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

772 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now