|
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, |
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, |
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, |
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, |
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 |
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, |
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 |
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, |
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, |
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, |
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, |
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, |
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% |
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% |
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% |
| All times are GMT +1. The time now is 12:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com