VBA security

[ExcelUser718]

Hi all,

I'm trying to set up such that a macro will choose not to execute based on a list of pre-approved MAC addresses. is that possible? and how?

[Tarball]

I dont see why this wouldnt be possible. With computers anything is possible

You would have to hard code the MAC Addressess or better yet put them in a secure file that the Excel would have to read. My first guess is to use the Shell command to run a DOS command to get the MAC address (unless there is another way). Example C:\ ipconfig /all . This returns all of the networking parms on your Windows machine (another assumption is that you are actually using Windows + Office and not a Open Office on Linux). Ipconfig /all returns alot of data that you would have to parse. But assuming that you can parse it to get the MAC address then all you would have to do is validate it against your master list.