login username
 

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

login username
 

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

login username
 

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

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