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

[Guest]

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

 

[Bob Phillips]

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
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Guest]

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}"

 

[PCLIVE]

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
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Guest]

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?

 

[Gord Dibben]

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