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)


--
Regards,

Peo Sjoblom



"Pegasus" wrote in message
...
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?


"Peo Sjoblom" wrote in message
...
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)


--
Regards,

Peo Sjoblom



"Pegasus" wrote in message
...
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?

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 ö


--
Regards,

Peo Sjoblom



"Pegasus" wrote in message
...
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?


"Peo Sjoblom" wrote in message
...
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)


--
Regards,

Peo Sjoblom



"Pegasus" wrote in message
...
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?

Good idea. I'll do this unless someone can tell me how to
disable the inbuilt shortcuts.


"Peo Sjoblom" wrote in message
...
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 ö


--
Regards,

Peo Sjoblom



"Pegasus" wrote in message
...
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?


"Peo Sjoblom" wrote in message
...
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)


--
Regards,

Peo Sjoblom



"Pegasus" wrote in message
...
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?

Drats. Macros can only be assigned to Ctrl+letter, not to
Ctrl+;. Any other suggestions?


"Peo Sjoblom" wrote in message
...
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 ö


--
Regards,

Peo Sjoblom



"Pegasus" wrote in message
...
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?


"Peo Sjoblom" wrote in message
...
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)


--
Regards,

Peo Sjoblom



"Pegasus" wrote in message
...
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?

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



"Pegasus (MVP)" wrote:

Drats. Macros can only be assigned to Ctrl+letter, not to
Ctrl+;. Any other suggestions?

"Peo Sjoblom" wrote in message
...
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 ö


--
Regards,

Peo Sjoblom



"Pegasus" wrote in message
...
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?


"Peo Sjoblom" wrote in message
...
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)


--
Regards,

Peo Sjoblom



"Pegasus" wrote in message
...
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?









--

Dave Peterson

Tue, 26 Jun 2007 22:23:54 +0200 from Pegasus (MVP) :

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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Tue, 26 Jun 2007 08:49:50 -0700 from Peo Sjoblom :
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 å


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

"Stan Brown" wrote in message
t...
Tue, 26 Jun 2007 08:49:50 -0700 from Peo Sjoblom :
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.


Care to share which versions of windows it doesn't work with regards to the
above mentioned characters?


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

"Stan Brown" wrote in message
t...
Tue, 26 Jun 2007 08:49:50 -0700 from Peo Sjoblom :
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 å


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

I currently use a redesigned keyboard map as explained
he 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)