Bloquear a função Print Screen

joseso

26-11-2017 22:54:44

Ola Pessoal,
Estou tendo um problema com o código para bloquear a função Print Screen na planilha que tenho.
Esse código serve para os dois modelos 32bit e 64bit.

Porém ele não esta funcionando ainda, pelo menos na maquina da empresa que usa 64 bit. Não sou grande conhecedor do VBA, mas me viro, pelo menos cheguei ate esse código..rsrs

Seguinte:
Na empresa onde trabalho que irei utilizar, existe dois tipos de computadores, uma Cpu comum e a outra é os modelos que vão atras do monitor.
Quando adiciono esse código na cpu que vai atras do monitor aparece em destaque no código (ver Print Erro1), e quando adiciono na Cpu comum não aparece nada, mas também não funciona.

Porém quando clico em Compilar VBA Project aparece o seguinte erro (Print Novo erro).

Código: Selecionar todos

Option Explicit

Private Type KBDLLHOOKSTRUCT
    vkCode As Long
    scanCode As Long
    flags As Long
    time As Long
    dwExtraInfo As Long
End Type

#If  VBA7 Then
    Private Declare PtrSafe Function SetWindowsHookEx Lib "user32" Alias "SetWindowsHookExA" (ByVal idHook As Long, ByVal lpfn As LongPtr, ByVal hmod As LongPtr, ByVal dwThreadId As Long) As LongPtr
    Private Declare PtrSafe Function UnhookWindowsHookEx Lib "user32" (ByVal hhk As LongPtr) As Long
    Private Declare PtrSafe Function CallNextHookEx Lib "user32" (ByVal hHook As LongPtr, ByVal ncode As Long, ByVal wParam As LongPtr, lParam As Any) As LongPtr
    Private Declare PtrSafe Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (Destination As Any, Source As Any, ByVal Length As LongPtr)
    Private hHook As LongPtr
#Else 
    Private Declare Function SetWindowsHookEx Lib "user32" Alias "SetWindowsHookExA" (ByVal idHook As Long, ByVal lpfn As Long, ByVal hmod As Long, ByVal dwThreadId As Long) As Long
    Private Declare Function UnhookWindowsHookEx Lib "user32" (ByVal hhk As Long) As Long
    Private Declare Function CallNextHookEx Lib "user32" (ByVal hHook As Long, ByVal ncode As Long, ByVal wParam As Long, lParam As Any) As Long
    Private Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (Destination As Any, Source As Any, ByVal Length As Long)
    Private hHook As Long
#End  If

Private Const WH_KEYBOARD_LL = &HD
Private Const WM_KEYDOWN = &H100
Private Const WM_SYSKEYDOWN = &H104
Private Const HC_ACTION = 0
Private Const VK_PRINTSCREEN = &H2C

#If  VBA7 Then
    Public Function SetKeyboardHook() As LongPtr
        Dim hInstance As LongPtr
        hInstance = Application.HinstancePtr
#Else 
    Public Function SetKeyboardHook() As Long
        Dim hInstance As Long
        hInstance = Application.hInstance
#End  If

    If hHook = 0 Then
        hHook = SetWindowsHookEx(WH_KEYBOARD_LL, AddressOf LowLevelKeyboardProc, hInstance, 0)
        SetKeyboardHook = hHook
    End If
End Function

Public Sub UnsetKeyboardHook()
    Call UnhookWindowsHookEx(hHook)
    hHook = 0
End Sub


#If  VBA7 Then
    Private Function LowLevelKeyboardProc(ByVal ncode As Long, ByVal wParam As LongPtr, ByVal lParam As LongPtr) As LongPtr
#Else 
    Private Function LowLevelKeyboardProc(ByVal ncode As Long, ByVal wParam As Long, ByVal lParam As Long) As Long
#End  If

    Dim lpllkHookStruct As KBDLLHOOKSTRUCT

    If ncode = HC_ACTION Then
        Call CopyMemory(lpllkHookStruct, ByVal lParam, Len(lpllkHookStruct))
        If lpllkHookStruct.vkCode = VK_PRINTSCREEN Then
            LowLevelKeyboardProc = -1
            Exit Function
        Else
            LowLevelKeyboardProc = CallNextHookEx(hHook, ncode, wParam, lParam)
        End If
    Else
        LowLevelKeyboardProc = CallNextHookEx(hHook, ncode, wParam, lParam)
    End If
    
End Function

Se alguém puder dar uma força, agradeço.