The "F1-12" buttons have been disabled in excel. How to repair ?

J

Jon Peltier

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

Application.OnKey "{F1}"

- Jon
 
G

Gord Dibben

Have you got one of those keyboards with the F-Lock

Punch it once to toogle on or off...........I forget which is which.


Gord Dibben MS Excel MVP
 
T

Thomas

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
 
G

Gord Dibben

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
 
J

Jon Peltier

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
 
T

Thomas

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
 
J

Jon Peltier

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
 
T

Thomas

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
 
J

Jon Peltier

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
 
Top