login username

[Ranjit kurian]

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...

 

[Jim Thomlinson]

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...

 

[Mike H]

Hi,

The answer and the security; or lack of security, issues are the same as I
gave in your other post. Instead of opening a text file open a workbook and
verify the username against the list.

Mike