View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default The "F1-12" buttons have been disabled in excel. How to repair

Fn or fn is different: it allows you to get extended capabilities on the
laptop. A plug in keyboard generally doesn't have this, because many of the
fn keys are irrelevant to a desktop machine.

This is obviously not an Excel issue, since changing the keyboard (via the
docking station) causes the problem.

Does the Logitech have an F-Lock key? Or perhaps there is some setting in
the control panel applet that handles the keyboard. Maybe the keyboard
drivers are out of date or incompatible with the setup. Try using a
different keyboard, or try plugging the Logitech directly into the laptop.

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


"Thomas" wrote in message
...

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
?