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
?