Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2003 - Use of Control-F3
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, |
#2
|
|||
|
|||
Works fine for me. (xl2003)
Bob Umlas Excel MVP "Jim May" wrote in message news:uG1Oe.16199$Co1.13884@lakeread01... 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, |
#3
|
|||
|
|||
Is there anything that I can do to "trouble-shoot"
(and solve) this problem? PS; I'm glad it works for you. "Bob Umlas" wrote in message ... Works fine for me. (xl2003) Bob Umlas Excel MVP "Jim May" wrote in message news:uG1Oe.16199$Co1.13884@lakeread01... 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, |
#4
|
|||
|
|||
This is also working in 2003
Do you have a keyboard with a F Lock key ? -- Regards Ron de Bruin http://www.rondebruin.nl "Jim May" wrote in message news:dJ3Oe.17241$Co1.6609@lakeread01... Is there anything that I can do to "trouble-shoot" (and solve) this problem? PS; I'm glad it works for you. "Bob Umlas" wrote in message ... Works fine for me. (xl2003) Bob Umlas Excel MVP "Jim May" wrote in message news:uG1Oe.16199$Co1.13884@lakeread01... 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, |
#5
|
|||
|
|||
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??? Jim May wrote: Is there anything that I can do to "trouble-shoot" (and solve) this problem? PS; I'm glad it works for you. "Bob Umlas" wrote in message ... Works fine for me. (xl2003) Bob Umlas Excel MVP "Jim May" wrote in message news:uG1Oe.16199$Co1.13884@lakeread01... 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, -- Dave Peterson |
#6
|
|||
|
|||
Ron,
I'm not familiar with a "F-Lock key"; So, maybe I don't have one.. Tks, Jim "Ron de Bruin" wrote in message ... This is also working in 2003 Do you have a keyboard with a F Lock key ? -- Regards Ron de Bruin http://www.rondebruin.nl "Jim May" wrote in message news:dJ3Oe.17241$Co1.6609@lakeread01... Is there anything that I can do to "trouble-shoot" (and solve) this problem? PS; I'm glad it works for you. "Bob Umlas" wrote in message ... Works fine for me. (xl2003) Bob Umlas Excel MVP "Jim May" wrote in message news:uG1Oe.16199$Co1.13884@lakeread01... 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, |
#7
|
|||
|
|||
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 "Dave Peterson" wrote in message ... 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??? Jim May wrote: Is there anything that I can do to "trouble-shoot" (and solve) this problem? PS; I'm glad it works for you. "Bob Umlas" wrote in message ... Works fine for me. (xl2003) Bob Umlas Excel MVP "Jim May" wrote in message news:uG1Oe.16199$Co1.13884@lakeread01... 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, -- Dave Peterson |
#8
|
|||
|
|||
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 "Jim May" wrote in message news:3c9Oe.17260$Co1.15002@lakeread01... Ron, I'm not familiar with a "F-Lock key"; So, maybe I don't have one.. Tks, Jim "Ron de Bruin" wrote in message ... This is also working in 2003 Do you have a keyboard with a F Lock key ? -- Regards Ron de Bruin http://www.rondebruin.nl "Jim May" wrote in message news:dJ3Oe.17241$Co1.6609@lakeread01... Is there anything that I can do to "trouble-shoot" (and solve) this problem? PS; I'm glad it works for you. "Bob Umlas" wrote in message ... Works fine for me. (xl2003) Bob Umlas Excel MVP "Jim May" wrote in message news:uG1Oe.16199$Co1.13884@lakeread01... 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, |
#9
|
|||
|
|||
Hi Chip
I hate it that you must press it to enable normal F-Key behavior. -- Regards Ron de Bruin http://www.rondebruin.nl "Chip Pearson" wrote in message ... 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 "Jim May" wrote in message news:3c9Oe.17260$Co1.15002@lakeread01... Ron, I'm not familiar with a "F-Lock key"; So, maybe I don't have one.. Tks, Jim "Ron de Bruin" wrote in message ... This is also working in 2003 Do you have a keyboard with a F Lock key ? -- Regards Ron de Bruin http://www.rondebruin.nl "Jim May" wrote in message news:dJ3Oe.17241$Co1.6609@lakeread01... Is there anything that I can do to "trouble-shoot" (and solve) this problem? PS; I'm glad it works for you. "Bob Umlas" wrote in message ... Works fine for me. (xl2003) Bob Umlas Excel MVP "Jim May" wrote in message news:uG1Oe.16199$Co1.13884@lakeread01... 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, |
#10
|
|||
|
|||
I hate it that you must press it to enable normal F-Key
behavior. 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 "Ron de Bruin" wrote in message ... Hi Chip I hate it that you must press it to enable normal F-Key behavior. -- Regards Ron de Bruin http://www.rondebruin.nl "Chip Pearson" wrote in message ... 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 "Jim May" wrote in message news:3c9Oe.17260$Co1.15002@lakeread01... Ron, I'm not familiar with a "F-Lock key"; So, maybe I don't have one.. Tks, Jim "Ron de Bruin" wrote in message ... This is also working in 2003 Do you have a keyboard with a F Lock key ? -- Regards Ron de Bruin http://www.rondebruin.nl "Jim May" wrote in message news:dJ3Oe.17241$Co1.6609@lakeread01... Is there anything that I can do to "trouble-shoot" (and solve) this problem? PS; I'm glad it works for you. "Bob Umlas" wrote in message ... Works fine for me. (xl2003) Bob Umlas Excel MVP "Jim May" wrote in message news:uG1Oe.16199$Co1.13884@lakeread01... 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, |
#11
|
|||
|
|||
I agree for 100%
-- Regards Ron de Bruin http://www.rondebruin.nl "Chip Pearson" wrote in message ... I hate it that you must press it to enable normal F-Key behavior. 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 "Ron de Bruin" wrote in message ... Hi Chip I hate it that you must press it to enable normal F-Key behavior. -- Regards Ron de Bruin http://www.rondebruin.nl "Chip Pearson" wrote in message ... 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 "Jim May" wrote in message news:3c9Oe.17260$Co1.15002@lakeread01... Ron, I'm not familiar with a "F-Lock key"; So, maybe I don't have one.. Tks, Jim "Ron de Bruin" wrote in message ... This is also working in 2003 Do you have a keyboard with a F Lock key ? -- Regards Ron de Bruin http://www.rondebruin.nl "Jim May" wrote in message news:dJ3Oe.17241$Co1.6609@lakeread01... Is there anything that I can do to "trouble-shoot" (and solve) this problem? PS; I'm glad it works for you. "Bob Umlas" wrote in message ... Works fine for me. (xl2003) Bob Umlas Excel MVP "Jim May" wrote in message news:uG1Oe.16199$Co1.13884@lakeread01... 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, |
#12
|
|||
|
|||
Thanks Chip;
No the F-Lock key is not a factor here; I have an older (but not too old) Keyboard. Thanks, Jim "Chip Pearson" wrote: 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 "Jim May" wrote in message news:3c9Oe.17260$Co1.15002@lakeread01... Ron, I'm not familiar with a "F-Lock key"; So, maybe I don't have one.. Tks, Jim "Ron de Bruin" wrote in message ... This is also working in 2003 Do you have a keyboard with a F Lock key ? -- Regards Ron de Bruin http://www.rondebruin.nl "Jim May" wrote in message news:dJ3Oe.17241$Co1.6609@lakeread01... Is there anything that I can do to "trouble-shoot" (and solve) this problem? PS; I'm glad it works for you. "Bob Umlas" wrote in message ... Works fine for me. (xl2003) Bob Umlas Excel MVP "Jim May" wrote in message news:uG1Oe.16199$Co1.13884@lakeread01... 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, |
#13
|
|||
|
|||
Ron/Chip and others with F-Lock
Jason Tsang has a couple of .REG files that will allow you to reverse the default behaviour of the F Lock key or disable it. One will change the default to "Off". http://mvps.org/jtsang/flock.html The other will eliminate the F Lock feature totally. This one I use!! http://mvps.org/jtsang/flock-e.html Both are Zips have an Undo.REG and a Readme.txt file with them. Gord On Mon, 22 Aug 2005 16:57:31 +0200, "Ron de Bruin" wrote: I agree for 100% |
#14
|
|||
|
|||
Thanks Gord
I will look at it after work -- Regards Ron de Bruin http://www.rondebruin.nl "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Ron/Chip and others with F-Lock Jason Tsang has a couple of .REG files that will allow you to reverse the default behaviour of the F Lock key or disable it. One will change the default to "Off". http://mvps.org/jtsang/flock.html The other will eliminate the F Lock feature totally. This one I use!! http://mvps.org/jtsang/flock-e.html Both are Zips have an Undo.REG and a Readme.txt file with them. Gord On Mon, 22 Aug 2005 16:57:31 +0200, "Ron de Bruin" wrote: I agree for 100% |
#15
|
|||
|
|||
Working great
Thanks Jason and Gord -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Thanks Gord I will look at it after work -- Regards Ron de Bruin http://www.rondebruin.nl "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Ron/Chip and others with F-Lock Jason Tsang has a couple of .REG files that will allow you to reverse the default behaviour of the F Lock key or disable it. One will change the default to "Off". http://mvps.org/jtsang/flock.html The other will eliminate the F Lock feature totally. This one I use!! http://mvps.org/jtsang/flock-e.html Both are Zips have an Undo.REG and a Readme.txt file with them. Gord On Mon, 22 Aug 2005 16:57:31 +0200, "Ron de Bruin" wrote: I agree for 100% |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Help in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Displaying MS Excel Chart control in ASP.NET Application | Charts and Charting in Excel |