OnKey to disable keys

[sooprmn]

I HAVE THE FOLLOWING CODE IN MY THIS WORKBOOK CODE FORM UNDER WORKBOOK OPEN:

Application.OnKey "{CAPSLOCK}", ""

Application.OnKey "{F1}", ""

THE {F1} DISABLES PERFECTLY, BUT THE CAPSLOCK DOES NOT. WHAT IS THE PROBLEM??

THANKS.

 

[headtoadie]

Check this post:

http://www.mrexcel.com/board2/viewtopic.php?t=115168&highlight=capslock

HT

 

[sooprmn]

I cannot get the link to work. I get a server error after 3 - 5 minutes.

 

[sooprmn]

anyone???

 

[ACommandLineKindaGuy]

Link worked fine for me...