Well.. just about everything you described is POSSIBLE.
what would you PREFER.
ActiveWorkbook.Path will give you the PATH name of the file.
I use absolute pathnames instead of mapped drives because users
may have different drives mapped.
so, my shortcuts point to \\servername\pathname rather than
"G:\pathname"
In you macro, test for this path, then if doesn't match, exit sub.
If you want to match usernames, let me know and I'll locate the code for that.