Excel 2003 - Use of Control-F3

J

Jim May

recently switched to xl2003;
just noticed that when i use
the old stand-by Ctl+F3 to
bring up the Range Names Box,
Nothing Happens... Is this 2003 normal?
Can I institute myself?
TIA,
 
J

Jim May

Is there anything that I can do to "trouble-shoot"
(and solve) this problem?

PS; I'm glad it works for you.
 
D

Dave Peterson

I'd start excel in safe mode, then test the ctrl-f3 combo.

close excel
windows start button|Run
excel /safe

And just hit ctrl-F3.

===
If it works in safe mode, it could be a macro that's stolen the ctrl-F3 combo???

A simple command like:
Application.OnKey "^{F3}", ""
could be the culprit.

I'd search any addin/workbook that opens when excel opens.

ps.

Application.OnKey "^{F3}"

should restore it (temporarily???) to its original state.


==========
And I think I'd try both ctrl keys, too. Maybe it's a hardware problem with the
keyboard???
 
J

Jim May

Tried Everything you suggested Dave;
but No cigar!!
The Ctrl+Shift+F3 brings up the Create Names Box;
Ctrl+Alt+Delete bring up the Tabk Manager, etc...
hummmm....
appreciate you suggestions;
Jim
 
C

Chip Pearson

I'm not familiar with a "F-Lock key";

The newer Microsoft Natural Keyboards have dual function F-keys.
By default, they don't behave like normal F-keys. The keyboard
has a key to enable normal F-Key behavior. This key is to the
right of the F12 key.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
C

Chip Pearson

I hate it that you must press it to enable normal F-Key
behavior.
Click to expand...

I do to. They should have made it default to normal F-key
behavior, and made it a mechanical switch so it would retain the
setting after a reboot.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
J

Jim May

Thanks Chip;
No the F-Lock key is not a factor here;
I have an older (but not too old) Keyboard.
Thanks,
Jim
 
Top