Open File If MAC Address Matches With That Mentioned In The Code

[hrayani]

Hello Friends,

Is it possible to Open a file only for specific computers.

A VBA code for let’s say 3 MAC Addresses is linked with Workbook Open Event & the file should open for those 3 computers who’s MAC Addresses are there in the code - otherwise a msg box should prompt saying that you are not allowed to open the file.

Regards,

Humayun

 

[Rijnsent]

Hi Humayun,
you can cover that with some VBA, but a skilled person could circumvent that protection.
You can us the Workbook_Open() sub to run some code on opening that excel. In that module you can e.g. use this code to get the MAC address: https://excelhub.org/mac-address-lookup-in-excel-vba-code/ and match it with your list. Having said that, if the user simply refuses to run macros, the workbook wil open, but that protection won't work. I guess an easier way is to simply password-protect the file and give the users that password (but there are online a couple of excel-password *******s out there).
Hope that helps a bit,
Koen