View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
John Bundy John Bundy is offline
external usenet poster
 
Posts: 93
Default Block keyboard input

More specific would help but is this what you want?

True if Microsoft Excel is in interactive mode; this property is usually
True. If you set the this property to False, Microsoft Excel will block all
input from the keyboard and mouse (except input to dialog boxes that are
displayed by your code). Blocking user input will prevent the user from
interfering with the macro as it moves or activates Microsoft Excel objects.
Read/write Boolean

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"jiebke" wrote in message
ups.com...
Can someone please help me. It's frustrating not to find a solution to
such a small problem!

Thanks in advance!