is there a way to check who has opened the macro?

Question

i have an XLAM macro that runs as an add in. can i write a script in any language to identify the user (IP address or name of computer) who is currently using the macro??

Answer 1

Why not?
Use the Application.UserName property.

If that's not enough, then use the GetComputerName function:

Private Declare Function GetComputerName Lib "kernel32.dll" Alias "GetComputerNameA" (ByVal lpBuffer As String, ByRef nSize As Long) As Long