Can't use a password as the user who is allowed just e-mails it to
someone who shouldn't have it and just tells the password

Mike wrote:

why don't you use a password?

"Sean" wrote:

Is it possible to deny access to open an Excel file except to specified
user?

I assume this code as well as the user access list would go within the
ThisWorksheet. In that on opening the file, it would compare the
Computer user logged in to the list and if "Joe Bloggs" or "Joe Public"
is listed it would allow it to open, otherwise a message "Go Away"
would appear and file would not open

Is this possible, or is it way too advanced?

Thanks