I did something on my keyboard and disabled "F2". How do I turn it back 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?

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?

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?

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 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?