View Single Post
  #10   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

If you had an F Lock key, you'd have tripped over it by now. It might be a
"feature" of Microsoft's more recent ergonomic keyboards.

I'd have switched keyboards already.

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


"Thomas" wrote in message
...

Thanks again for your help. I've tried to reset the keyboard settings and
reinstalled the driver (a couple of times). Problem is I cant find the
damn
F-lock key, and in the settings menu there is no sight of controls of F
keys.

I guess I may end up using another keyboard

Thomas

"Jon Peltier" wrote:

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
?