Macro Shortcut keys w/ Caps Lock on Windows 2000

D

D Crisman

Running Excel 2000 on Windows 2000. Make a macro & set the shortcut key
to Ctrl+Shift+N (or any letter). If you type Ctrl+Shift+N the macro
works fine. If you have Caps Lock on and type Ctrl+Shift+N nothing
happens and Ctrl+N just opens a new workbook (as it normally does).

Now change the shortcut key to Ctrl+N and these run the macro:
Ctrl+N
Ctrl+Shift+N with Caps Lock on

On windows 98 the macro shortcut keys ignore the Caps Lock. In Word for
both Windows 98 & 2000 the shortcut keys ignore the Caps Lock key.

Does anyone know why this happens on Windows 2000 and how to fix it. Is
it just a bug in Excel on Windows 2000?

dc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Menu Macro Not Executing - Need Help 1
VBA word change keys 0
How to lock the Ctrl key? (as locking the Shift key w/Caps Lock) 2
SOLVED! Allow Autocorrect is the culprit when caps lock fouls up AutoExpand in combo boxes 0
Why does the caps lock not work on the # like 9 = ( & 0 = ) 2
I have nearly run out of Shortcut Keys 4
Control key 'dis-abled' for Ctrl+Shift+arrow 0
Excel 2003 Macro shortcut keys 2

Top