How to disable copy-as-image in Excel?

Solution 1:

You can try this VBA code to check whether Clipboard has Image Data or not, and if it has, then this code will prevent to paste it.

Remember, the effect of Ctrl+C can be stopped only by disable it. So I do believe that this is the best possible solution.

Note, before you execute this VBA code, in VB Editor click Tool then References and select Microsoft Form 2.0 Object Library.

Better you use the code with Workbook open event.

Private Sub Workbook_open()

   Dim BufObj As MSForms.DataObject
   Set BufObj = New MSForms.DataObject

   BufObj.GetFromClipboard

   On Error Resume Next
   ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:=False

    If Err Then
       MsgBox "Nothing in ClipBoard!": Err.Clear

    Else

      MsgBox "Picture in ClipBoard": Err.Clear
      Application.CutCopyMode = False
      Application.DisplayAlerts = False

   End If

End Sub

NB: You also need to create one Command Button Click event to activate the Cut Copy Mode. This simple code will do it.

Application.CutCopyMode = True

Application.DisplayAlerts = Ture

This code was tested by me, before I've posted it here.