Am using a wireless keyboard and would like to know when caps is on or off in
WORD. I notice that it appears in excel as well as NUM for number lock. I'm
working in Windows XP.

You may find that you get a better answer in an MSWord newsgroup.

(or just look at the light on the keyboard. I didn't see an indicator in
MSWord.)

disenchantedstar wrote:

Am using a wireless keyboard and would like to know when caps is on or off in
WORD. I notice that it appears in excel as well as NUM for number lock. I'm
working in Windows XP.

--

Dave Peterson

Just remove the key, then if it does get invoked which shouldn't happen, but at least it
will happen less frequently. and you can then use a match stick sized tool
to restore it to non Caps.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"disenchantedstar" wrote in message
...
Am using a wireless keyboard and would like to know when caps is on or off in
WORD. I notice that it appears in excel as well as NUM for number lock. I'm
working in Windows XP.

I believe wireless keyboards has removed that light to conserve energy

--
Peo



Portland, Oregon




"Dave Peterson" wrote in message
...
You may find that you get a better answer in an MSWord newsgroup.

(or just look at the light on the keyboard. I didn't see an indicator in
MSWord.)

disenchantedstar wrote:

Am using a wireless keyboard and would like to know when caps is on or
off in
WORD. I notice that it appears in excel as well as NUM for number lock.
I'm
working in Windows XP.

--

Dave Peterson

Great suggestion, David!!!

Caps lock should be as inaccessible as scroll lock. I'm sick of
"shouting" for most of a sentence just because I INADVERTENTLY TOUCHED
IT WHEN REACHING FOR THE SHIFT KEY. Drat ... did it again.

Can the caps lock be disabled in Excel or used for some other purpose?
Is there some utility which enables this?

David McRitchie Wrote:
Just remove the key, then if it does get invoked which shouldn't
happen, but at least it
will happen less frequently. and you can then use a match stick sized
tool
to restore it to non Caps.



--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=529440

I've saved this from other posts--it includes other stuff, but also the
capslock.

Option Explicit
' Code from "VBA Developer's Handbook" (Sybex, 1997):
Private Declare Function GetKeyState Lib "user32" (ByVal nVirtKey As Long) _
As Integer
Private Declare Function GetKeyboardState Lib "user32" (pbKeyState As Byte) _
As Long
Private Declare Function SetKeyboardState Lib "user32" (lppbKeyState As Byte) _
As Long
Function GetCapslock() As Boolean
' Return or set the Capslock toggle
GetCapslock = CBool(GetKeyState(vbKeyCapital) And 1)
End Function
Function GetNumlock() As Boolean
' Return or set the Numlock toggle.
GetNumlock = CBool(GetKeyState(vbKeyNumlock) And 1)
End Function
Sub SetCapslock(Value As Boolean)
' Return or set the Capslock toggle.
Call SetKeyState(vbKeyCapital, Value)
End Sub
Sub SetNumlock(Value As Boolean)
' Return or set the Numlock toggle.
Call SetKeyState(vbKeyNumlock, Value)
End Sub
Private Sub SetKeyState(intKey As Integer, fTurnOn As Boolean)
Dim abytBuffer(0 To 255) As Byte
GetKeyboardState abytBuffer(0)
abytBuffer(intKey) = CByte(Abs(fTurnOn))
SetKeyboardState abytBuffer(0)
End Sub
Sub Caps_on()
If GetCapslock = False Then Call SetKeyState(vbKeyCapital, True)
End Sub
Sub Caps_Off()
If GetCapslock = True Then Call SetKeyState(vbKeyCapital, False)
End Sub
Sub auto_open()
Application.OnKey "{CAPSLOCK}", "TurnItOff"
End Sub
Sub auto_close()
Application.OnKey "{CAPSLOCK}"
End Sub
Sub TurnItOff()
If GetCapslock = True Then
Call SetKeyState(vbKeyCapital, False)
Beep
End If
End Sub

If you create a workbook with this code in it, then the auto_open procedure will
run and turn off the capslock whenever you click it.

If the OP is new to macros, then the OP can read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

ps. There's another option you may like better (I would).

Go to windows control panel|Accessibility options|keyboard tab
Turn on the ToggleKeys option.

You'll hear a beep when you hit capslock, numlock, or scrolllock.


John James wrote:

Great suggestion, David!!!

Caps lock should be as inaccessible as scroll lock. I'm sick of
"shouting" for most of a sentence just because I INADVERTENTLY TOUCHED
IT WHEN REACHING FOR THE SHIFT KEY. Drat ... did it again.

Can the caps lock be disabled in Excel or used for some other purpose?
Is there some utility which enables this?

David McRitchie Wrote:
Just remove the key, then if it does get invoked which shouldn't
happen, but at least it
will happen less frequently. and you can then use a match stick sized
tool
to restore it to non Caps.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=529440

--

Dave Peterson

So I guess that looking at the keyboard wouldn't be too effective <bg.

Peo Sjoblom wrote:

I believe wireless keyboards has removed that light to conserve energy

--
Peo

Portland, Oregon

"Dave Peterson" wrote in message
...
You may find that you get a better answer in an MSWord newsgroup.

(or just look at the light on the keyboard. I didn't see an indicator in
MSWord.)

disenchantedstar wrote:

Am using a wireless keyboard and would like to know when caps is on or
off in
WORD. I notice that it appears in excel as well as NUM for number lock.
I'm
working in Windows XP.

--

Dave Peterson

--

Dave Peterson

Dave, you're a champ!!

This is a great solution. As long as there is sufficient volume, this
seems to work in all circumstances in all applications. Solves
disenchantedstar's wireless keyboard CAPS LOCK problem and my separate
problem as well. This option should be activated by default on windows
installation, but that's another issue.

Many thanks


Dave Peterson Wrote:

Go to windows control panel|Accessibility options|keyboard tab
Turn on the ToggleKeys option.

You'll hear a beep when you hit capslock, numlock, or scrolllock.
Dave Peterson


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=529440

Only if you want to conserve your energy <bg

--

Peo


Portland, Oregon




"Dave Peterson" wrote in message
...
So I guess that looking at the keyboard wouldn't be too effective <bg.

Peo Sjoblom wrote:

I believe wireless keyboards has removed that light to conserve energy

--
Peo

Portland, Oregon

"Dave Peterson" wrote in message
...
You may find that you get a better answer in an MSWord newsgroup.

(or just look at the light on the keyboard. I didn't see an indicator
in
MSWord.)

disenchantedstar wrote:

Am using a wireless keyboard and would like to know when caps is on or
off in
WORD. I notice that it appears in excel as well as NUM for number
lock.
I'm
working in Windows XP.

--

Dave Peterson

--

Dave Peterson

It's one of the first things I do when I (try to) help someone--whether they
want it or not!

John James wrote:

Dave, you're a champ!!

This is a great solution. As long as there is sufficient volume, this
seems to work in all circumstances in all applications. Solves
disenchantedstar's wireless keyboard CAPS LOCK problem and my separate
problem as well. This option should be activated by default on windows
installation, but that's another issue.

Many thanks

Dave Peterson Wrote:

Go to windows control panel|Accessibility options|keyboard tab
Turn on the ToggleKeys option.

You'll hear a beep when you hit capslock, numlock, or scrolllock.
Dave Peterson

--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=529440

--

Dave Peterson

Ps.

MS has a download that you may like:

http://www.microsoft.com/downloads/d...displaylang=EN

or
http://snipurl.com/2z7v

It provides sounds (feedback) to lots of things that you do in any of the office
applications.

(I like it when I hit the delete key in error and clear contents that I didn't
mean to clear!)



John James wrote:

Dave, you're a champ!!

This is a great solution. As long as there is sufficient volume, this
seems to work in all circumstances in all applications. Solves
disenchantedstar's wireless keyboard CAPS LOCK problem and my separate
problem as well. This option should be activated by default on windows
installation, but that's another issue.

Many thanks

Dave Peterson Wrote:

Go to windows control panel|Accessibility options|keyboard tab
Turn on the ToggleKeys option.

You'll hear a beep when you hit capslock, numlock, or scrolllock.
Dave Peterson

--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=529440

--

Dave Peterson

Thanks Dave.

After installation & changing the annoying "clear" sound (attached to
the delete key) to delete.wav, the sounds were non-invasive &
appropriate. I can continue on my clumsy way now with some comfort.

Cheers,

Dave Peterson Wrote:
Ps.

MS has a download that you may like:

http://tinyurl.com/kyttd

or
http://snipurl.com/2z7v

It provides sounds (feedback) to lots of things that you do in any of
the office
applications.

(I like it when I hit the delete key in error and clear contents that I
didn't
mean to clear!)



--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=529440