ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   My "F2" function has been turned off, how do I turn it on? (https://www.excelbanter.com/excel-worksheet-functions/142444-my-f2-function-has-been-turned-off-how-do-i-turn.html)

Sometimes I need assistance...

My "F2" function has been turned off, how do I turn it on?
 
I did something on my keyboard and disabled "F2". How do I turn it back on?

Bob Phillips

My "F2" function has been turned off, how do I turn it on?
 
Try

ONKEY {F2}

in the VBIDE immediate window.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Sometimes I need assistance..." <Sometimes I need
wrote in message
...
I did something on my keyboard and disabled "F2". How do I turn it back
on?




Barb Reinhardt

My "F2" function has been turned off, how do I turn it on?
 
You may have something in code for a workbook you are using that turns it
off. To turn it on, you can do the following, but this is no guarantee that
it won't be turned back off by other code:

Alt F11
CTRL G

Enter this in the IMMEDIATE window.

Application.OnKey "{f2}"

"Sometimes I need assistance..." wrote:

I did something on my keyboard and disabled "F2". How do I turn it back on?


PCLIVE

My "F2" function has been turned off, how do I turn it on?
 
Try going to Tools-Options and then the Edit tab.
Make sure there is a check in 'Edit directly in cell'.

Even with that unchecked, the F2 function still works, but it places your
blinking cursor in the address bar and not the cell itself.

HTH,
Paul

"Sometimes I need assistance..." <Sometimes I need
wrote in message
...
I did something on my keyboard and disabled "F2". How do I turn it back
on?




Sometimes I need assistance...[_2_]

My "F2" function has been turned off, how do I turn it on?
 
Thank you for the reply but, it is actually all my function keys I turned off.
It should be something simple like 'ctrl' 'alt' 'some other key'

Any ideas?

"Barb Reinhardt" wrote:

You may have something in code for a workbook you are using that turns it
off. To turn it on, you can do the following, but this is no guarantee that
it won't be turned back off by other code:

Alt F11
CTRL G

Enter this in the IMMEDIATE window.

Application.OnKey "{f2}"

"Sometimes I need assistance..." wrote:

I did something on my keyboard and disabled "F2". How do I turn it back on?


Gord Dibben

My "F2" function has been turned off, how do I turn it on?
 
All functions keys?

Do you have one of those keyboards with the F Lock toggle key?

If so, change the mode.


Gord Dibben MS Excel MVP

On Fri, 11 May 2007 07:47:00 -0700, Sometimes I need assistance...
m wrote:

Thank you for the reply but, it is actually all my function keys I turned off.
It should be something simple like 'ctrl' 'alt' 'some other key'

Any ideas?

"Barb Reinhardt" wrote:

You may have something in code for a workbook you are using that turns it
off. To turn it on, you can do the following, but this is no guarantee that
it won't be turned back off by other code:

Alt F11
CTRL G

Enter this in the IMMEDIATE window.

Application.OnKey "{f2}"

"Sometimes I need assistance..." wrote:

I did something on my keyboard and disabled "F2". How do I turn it back on?




All times are GMT +1. The time now is 07:20 PM.

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