Michael,

Does everyone have their own copy of Excel on their PC's??
i.e. Do they each have unique Usernames??
You can check by going into Tools/Options/General

If they do, an easy way would be to just check the
Application.Username against a list and if on the list
allow them to open the file.

Post back with more info and I'll try to supply you with some
code based on your situation.

John

Michael wrote:

Hi Guys, Is it possible to create a log-on input box with
excel that will search a column of names before it will
allow access to a worksheet, maybe with a auto_open macro.

I am trying to avoid passwork protection and I only allow
certain members of staff access file, with giving
everybody a password.

Thanks for your help

Michael