Macro should not work any other computer

Hi janagan,

Though Excel is not secure, just to answer your question you could check the machine name that the code is being opened from and if it's not equal to yours end it, which would be something like this:

Option Explicit
Sub Macro1()
    
    Dim objWshNetwork As Object
    
    Set objWshNetwork = CreateObject("Wscript.Network")
    
    If objWshNetwork.computername <> "ABC123" Then '<= This would be your machine name
        MsgBox "The file is not permitted to be opened on this machine!!", vbCritical
        Set objWshNetwork = Nothing
        Exit Sub
    Else
        'Run your macro as the file has been opened from your machine
    End If
    
    Set objWshNetwork = Nothing

End Sub

Regards,

Robert