D Dave Peterson Dec 8, 2005 #2 Chip Pearson says that he actually "fixed" his keyboard by taking that key off. Others say that they left the key, but removed the spring underneath. But you could use a couple of macros (one to disable and one to enable): Option Explicit Sub disableF1() Application.OnKey "{f1}", "" End Sub This would toggle it back to normal. Sub enableF1() Application.OnKey "{f1}" End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm
Chip Pearson says that he actually "fixed" his keyboard by taking that key off. Others say that they left the key, but removed the spring underneath. But you could use a couple of macros (one to disable and one to enable): Option Explicit Sub disableF1() Application.OnKey "{f1}", "" End Sub This would toggle it back to normal. Sub enableF1() Application.OnKey "{f1}" End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm
R Ron de Bruin Dec 8, 2005 #3 Hi Dave This is one of the keys that if you are in Edit mode it is still working . I vote for this
