ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   F2 key is not functioning properly (https://www.excelbanter.com/excel-discussion-misc-queries/142053-f2-key-not-functioning-properly.html)

[email protected]

F2 key is not functioning properly
 
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


Barb Reinhardt

F2 key is not functioning properly
 
Try this:

Alt F11
CTRL G

Enter the following

Application.OnKey "{f2}"

HTH,
Barb Reinhardt
" wrote:

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



[email protected]

F2 key is not functioning properly
 
On May 8, 6:36 pm, Barb Reinhardt
wrote:
Try this:

Alt F11
CTRL G

Enter the following

Application.OnKey "{f2}"

HTH,
Barb Reinhardt



" wrote:
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- Hide quoted text -


- Show quoted text -


Thanks Barb. It still doesn't work. F2 still does the copying. Is
there any other way? Thank you!


Barb Reinhardt

F2 key is not functioning properly
 
Do you have any Workbook_Open code in the MyWorkbook module? If so, can you
post it here?

" wrote:

On May 8, 6:36 pm, Barb Reinhardt
wrote:
Try this:

Alt F11
CTRL G

Enter the following

Application.OnKey "{f2}"

HTH,
Barb Reinhardt



" wrote:
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- Hide quoted text -


- Show quoted text -


Thanks Barb. It still doesn't work. F2 still does the copying. Is
there any other way? Thank you!



[email protected]

F2 key is not functioning properly
 
On May 9, 6:21 am, Barb Reinhardt
wrote:
Do you have any Workbook_Open code in the MyWorkbook module? If so, can you
post it here?



" wrote:
On May 8, 6:36 pm, Barb Reinhardt
wrote:
Try this:


Alt F11
CTRL G


Enter the following


Application.OnKey "{f2}"


HTH,
Barb Reinhardt


" wrote:
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- Hide quoted text -


- Show quoted text -


Thanks Barb. It still doesn't work. F2 still does the copying. Is
there any other way? Thank you!- Hide quoted text -


- Show quoted text -


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



All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com