detect windows user name and allow access to excel file

Hi, how do I create a file on a network drive that can only be opened by a group of people? The idea is that this file will contain a list of people that can have access to the file written on one of the spreadsheet. When they try to open the file, a code runs and tries to match their windows log on name to the list in the file. If matched, file opens. If it doesn't, file closes.

Hi,

with VBA Environ function for example, you can read the USERNAME …

Or you just have to set the trustees of the file in Windows …

Hi Marc, how do I write the code for that?

It would be much better just to give them a password or put it in a folder only they can access. Doing this in code is fraught with issues