i do a lot of testing and i use a list of barcodes generated in Excel.
I copy the barcode i use, then change the color of the cell so i know which ones are used.
Is there a way a macro could automatically changes the color of the selected cell/s when i copy them using Ctrl + C.
I tried to record a macro and key bind it to Ctrl + C but it come with a Out of Stack Space error.

Sub Macro2()
'
' Macro2 Macro
'
' Keyboard Shortcut: Ctrl+c
'
    Range("E3").Select
    Application.Run "'LPN numbers.xlsx'!Macro2"
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .ThemeColor = xlThemeColorAccent4
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
End Sub