 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007Disable keyboard shortcuts
I use some keyboard shortcuts that are global to Windows, e.g. Ctrl+; to generate the letter "ö". This does not work in Excel because Ctrl+; inserts the current date. Is there a way to disable such inbuilt shortcuts in Excel 2003, either individually or the whole lot? If you are looking for an umlaut o like they are using in Sweden and Germany then you can use Alt + 148 for small letter, Alt + 153 for large for the other 2 Swedish letters you can use Alt + 132 and Alt + 134 for small and for large Alt + 142 and Alt + 143 (it's important to use the numpad keys for the numbers)  SignatureRegards, Peo Sjoblom >I use some keyboard shortcuts that are global to Windows, > e.g. Ctrl+; to generate the letter "ö". This does not work in > Excel because Ctrl+; inserts the current date. Is there a > way to disable such inbuilt shortcuts in Excel 2003, either > individually or the whole lot? Yes, I'm aware of this entry mode. Since it is a very cumbersone way of getting these letters on a laptop keyboard (where there is no numeric keypad!), I prefer to reprogram the keyboard itself, which works very nicely in all applications except in Excel. Do you know how to disable shortcuts in Excel? > If you are looking for an umlaut o like they are using in Sweden and > Germany then you can use Alt + 148 for small letter, Alt + 153 for large [quoted text clipped - 9 lines] >> way to disable such inbuilt shortcuts in Excel 2003, either >> individually or the whole lot? Why don't you just record a macro to your personal.xls when you do this and then assign the macros to keyboard shortcuts or menu icons ActiveCell.FormulaR1C1 = "ö" will insert the ö SignatureRegards, Peo Sjoblom > Yes, I'm aware of this entry mode. Since it is a very cumbersone > way of getting these letters on a laptop keyboard (where there is [quoted text clipped - 16 lines] >>> way to disable such inbuilt shortcuts in Excel 2003, either >>> individually or the whole lot? Good idea. I'll do this unless someone can tell me how to disable the inbuilt shortcuts. > Why don't you just record a macro to your personal.xls when you do this > and then assign the macros to keyboard shortcuts or menu icons [quoted text clipped - 24 lines] >>>> way to disable such inbuilt shortcuts in Excel 2003, either >>>> individually or the whole lot? Drats. Macros can only be assigned to Ctrl+letter, not to Ctrl+;. Any other suggestions? > Why don't you just record a macro to your personal.xls when you do this > and then assign the macros to keyboard shortcuts or menu icons [quoted text clipped - 24 lines] >>>> way to disable such inbuilt shortcuts in Excel 2003, either >>>> individually or the whole lot? You can use code to assign a non-letter: Option Explicit Sub Auto_Open() Application.OnKey "^;", "'" & ThisWorkbook.Name & "'!myMac" End Sub Sub Auto_Close() Application.OnKey "^;" End Sub Sub mymac() Selection.Value = "ö" End Sub > Drats. Macros can only be assigned to Ctrl+letter, not to > Ctrl+;. Any other suggestions? [quoted text clipped - 37 lines] > >>>> way to disable such inbuilt shortcuts in Excel 2003, either > >>>> individually or the whole lot? SignatureDave Peterson Thanks for your reply. I tried your suggestion and it almost works - but not quite! When I press "Ctrl+;" the first time then I get "ö" but when I press it a second time then I get nothing. Even worse: When I try to enter the word "söndag" then I get "s27/06/2007". Any other options or do I have to commit this one to the too-hard-basket? > You can use code to assign a non-letter: > [quoted text clipped - 51 lines] >> >>>> way to disable such inbuilt shortcuts in Excel 2003, either >> >>>> individually or the whole lot? If you're trying to run this macro while you're editing the cell, you're out of luck. Macros in excel won't work this way. > Thanks for your reply. > [quoted text clipped - 64 lines] > > > > Dave Peterson SignatureDave Peterson Intriguing. Excel macros won't work while I'm editing a cell but the inbuilt keyboard shortcuts do. That's why I was hoping that someone would know a way to turn them off! > If you're trying to run this macro while you're editing the cell, you're > out of [quoted text clipped - 72 lines] >> > >> > Dave Peterson I don't think I've ever seen a post where someone could get into the innards of excel and change its behavior like you want. I know that it's impossible for me to do <bg>. > Intriguing. Excel macros won't work while I'm editing a cell > but the inbuilt keyboard shortcuts do. That's why I was [quoted text clipped - 80 lines] > > > > Dave Peterson SignatureDave Peterson Thanks. I think I will now put the question directly to Microsoft under the MVP plan. Keep an eye on this thread in case you're interested. >I don't think I've ever seen a post where someone could get into the >innards of [quoted text clipped - 90 lines] >> > >> > Dave Peterson What kind of plan is that and what kind of MVP are you? SignatureRegards, Peo Sjoblom > Thanks. I think I will now put the question directly to Microsoft > under the MVP plan. Keep an eye on this thread in case you're [quoted text clipped - 97 lines] >>> > >>> > Dave Peterson Please drop me a line on pegasus_fnlATyahooDOTcom. > What kind of plan is that and what kind of MVP are you? > [quoted text clipped - 101 lines] >>>> > >>>> > Dave Peterson Tue, 26 Jun 2007 22:23:54 +0200 from Pegasus (MVP) <I.can@fly.com>: > Drats. Macros can only be assigned to Ctrl+letter, not to > Ctrl+;. Any other suggestions? http://www.autohotkey.com The cost is zero, and it works extremely well across applications. SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ > Tue, 26 Jun 2007 22:23:54 +0200 from Pegasus (MVP) <I.can@fly.com>: >> [quoted text clipped - 4 lines] > > The cost is zero, and it works extremely well across applications. Very nice tool, worth adding to my tool kit. Unfortunately it does not quite work in Excel. When I press Ctrl+; it generates the letter "Ö" as expected but when I press Ctrl+; again it generates 27/06/2007. It appears that the inbuilt Excel macro reasserts itself at this stage. It's a pity - I really like this tool! Wed, 27 Jun 2007 10:34:32 +0200 from Pegasus (MVP) <I.can@fly.com>: > > http://www.autohotkey.com > [quoted text clipped - 3 lines] > It appears that the inbuilt Excel macro reasserts itself at this stage. > It's a pity - I really like this tool! What does your .AHK file ook like? SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ > Wed, 27 Jun 2007 10:34:32 +0200 from Pegasus (MVP) <I.can@fly.com>: >> [quoted text clipped - 7 lines] > > What does your .AHK file ook like? Very simple! ^;:: send Ö return Sun, 1 Jul 2007 11:36:33 +0200 from Pegasus (MVP) <I.can@fly.com>: > > Wed, 27 Jun 2007 10:34:32 +0200 from Pegasus (MVP) <I.can@fly.com>: > >> [quoted text clipped - 12 lines] > send Ö > return Hmm -- works just fine for me. I hit Ctrl-; several times in succession and got Ö several times in succession. I don't know what to suggest; sorry. SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ Tue, 26 Jun 2007 08:49:50 -0700 from Peo Sjoblom <terre08@mvps.org>: > If you are looking for an umlaut o like they are using in Sweden and Germany > then you can use Alt + 148 for small letter, Alt + 153 for large > for the other 2 Swedish letters you can use Alt + 132 and Alt + 134 for > small and for large Alt + 142 and Alt + 143 The OEM characters that you suggest are discouraged because they will not necessarily appear the same on all Windows systems or in all fonts. Much, much better is to use the four-digit sequences, which will appear correctly in a greater range of circumstances: Alt-0214 Ö Alt-0246 ö Alt-0196 Ä Alt-0228 ä Alt-0216 Ø Alt-0248 ø Alt-0196 Æ Alt-0230 æ Alt-0197 Å Alt-0229 å SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ > Tue, 26 Jun 2007 08:49:50 -0700 from Peo Sjoblom <terre08@mvps.org>: >> If you are looking for an umlaut o like they are using in Sweden and [quoted text clipped - 6 lines] > not necessarily appear the same on all Windows systems or in all > fonts. Care to share which versions of windows it doesn't work with regards to the above mentioned characters? SignatureRegards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) > Tue, 26 Jun 2007 08:49:50 -0700 from Peo Sjoblom <terre08@mvps.org>: >> If you are looking for an umlaut o like they are using in Sweden and [quoted text clipped - 20 lines] > Alt-0197 Å > Alt-0229 å I currently use a redesigned keyboard map as explained here: http://www.microsoft.com/globaldev/tools/msklc.mspx. In essence this means that I am rolling my own keyboard and make it native to Windows - I even generate my own .DLL. It's the official MS keyboard remapper and it works across all Windows applications. I am fully aware of the numeric codes you quote. They are not really an option: They are clumsy at the best of times and become painful on a laptop with no numeric keypad. Pressing nine keys to get one character is a bit much! (Shift,NumLock,Alt,0,2,2,9,Shift,NumLock)
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.