View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Thomas Thomas is offline
external usenet poster
 
Posts: 107
Default The "F1-12" buttons have been disabled in excel. How to repair


Thanks for your help. However I still havent solved the issue. I can open
the VBA interface and the immediate window and have typed the code, but it
doesnt seem to help ? Im using Excel 2007 version.

Im using a docking station for a laptop, but with an additional Logitech
keyboard. The Fn key is on the laptop but I cant find it on the Logitech
keyboard. Weird thing is that F keys works normally when using the laptop
keyboard, but not when using the Logitech?

Thomas


"Jon Peltier" wrote:

Check out the F-Lock annoyance that Gord describes. On these keyboards, the
F keys by default don't do what you think they should. Another brilliant
advance in the science of usability.

If that isn't it, then in Excel, press Alt+F11 to open the VB Editor. Then
press Ctrl+G to open the Immediate Window. Type this line in the Immediate
Window and press Enter:

Application.OnKey "{F1}"

Go to Excel and see if F1 does anything. If it's fixed, go back to the VB
Editor and repeat the above for F2 through F12.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
You sure you don't have one of those keyboards with the F-Lock key?

Hard to envision that all your Fn keys would be disabled by Excel.


Gord Dibben MS Excel MVP

On Mon, 31 Mar 2008 01:41:02 -0700, Thomas

wrote:


Thanks for your help, but how do I reset default settings ? Dop I have to
open the VBA interfeace in an Excel workbook and then type the syntax ??

Thomas


"Jon Peltier" wrote:

Reset the keys to their default settings using this VBA syntax:

Application.OnKey "{F1}"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Thomas" wrote in message
...
The "F1-12" buttons have been disabled in excel. How to restore
default
settings
?