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

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

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

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
?

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

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

On Tue, 25 Mar 2008 08:38:03 -0700, Thomas
wrote:

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

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

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
?

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

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
?

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

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
?

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
?

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
?

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

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
?

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
?