Thread: vbKeyCapital
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jnf40 jnf40 is offline
external usenet poster
 
Posts: 103
Default vbKeyCapital

I have a workbook that when opened a box pops up for the user to enter a
password. I would like to have a message box pop up if the CapsLock is on,
this way if they can enter the password correctly. As it is now if they type
in the password and they have the CapsLock on it will only give them viewing
rights. Is it possible to have Excel recognize when the CapsLock is on, if so
how would I put this into code?
Thanks in advance,
jnf40