What you are asking for is realtively straight forward using an on open event
macro checking Environ("UserName") against your list with a
application.worksheetfunction.countif

That being said any security you put on the file will be relatively easy to
defeat by not enabling macros...
--
HTH...

Jim Thomlinson


"Ranjit kurian" wrote:

I have created a user.xls file which contain employees NT names in the first
column

I need a macro, so that when ever the person try to open my main excel file,
it
should check the NT name of his/her in user.xls file,and if the NT name
exist in
user.xls file he should be allowed to open my excel file...