F2 key is not functioning properly

  • Thread starter Thread starter connietan1127
  • Start date Start date
C

connietan1127

Hi, could anyone help me with resetting the F2 key? I used to be able
to enter the edit mode by hitting the F2 key, but right now, instead
of taking me to the edit mode, it does the "copy" funciton. I suspect
that it might have been interfered with some macros that I run before.
Does anyone know how can I fix this? Thank you very much!

Connie
 
Try this:

Alt F11
CTRL G

Enter the following

Application.OnKey "{f2}"

HTH,
Barb Reinhardt
 
Try this:

Alt F11
CTRL G

Enter the following

Application.OnKey "{f2}"

HTH,
Barb Reinhardt






- Show quoted text -
Click to expand...

Thanks Barb. It still doesn't work. F2 still does the copying. Is
there any other way? Thank you!
 
Do you have any Workbook_Open code in the MyWorkbook module? If so, can you
post it here?
 
Do you have any Workbook_Open code in the MyWorkbook module? If so, can you
post it here?






- Show quoted text -
Click to expand...

Barb, I figured out. I had another application opened in which F2 is
mapped to "pronounciation" function. I closed that application so F2
in excel is now functioning properly. Thanks very much for your
comments.

Connie
 
Back
Top