View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Excelibur[_6_] Excelibur[_6_] is offline
external usenet poster
 
Posts: 6
Default code to intercept 'printscreen' key?

To my knowledge, this is not possible. In the code window, type OnKey
and press F1 to get help on it. It displays all the keys you can
intercept in Excel.

If you really need it, it should be possible with external tools like
AutoIt, but I wouldn't recommend it as it will become a messy solution.

On 23 jan, 18:07, "Keith"
wrote:
Can anyone point me to a code snippet I could use to run a macro every time
the print screen key is pushed (after allowing the normal printscreen
function of capturing whatever is onscreen as an image)? Basically I want to
automate pasting the new image and doing some other stuff, but I want tit to
be dependent on the printscreen key.... also, I'd like this to occur even if
Excel is not the active window/application, just as long as it is open.

Is this possible, and if so, can anyone point me to examples of how to do
it?

Thanks!
Keith