Hi Lena,
Application.OnKey "{F1}", ""
changed the use of the F1 key by removing it.
By the way you can enter the above in the Intermediate Window in the VBE.

If you would like to run a macro instead see this posting by Dave Peterson


---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lena" wrote in message ...
OK, so there's no way to just change the shortcut?

"David McRitchie" skrev:

and to restore use of the F1 key use this line of code:
Application.OnKey "{F1}"