Workbook Security

[Robert_Conklin]

I have a workbook that I only want certain users to be able to open. I have a list of network usernames that should have access on a worksheet called "LISTS". The list of usernames is in column "M" (range M2:M159) that has a dataname of "usernames". How do I set up some VBA code to look at the Windows network username that is currently logged on and determine if that username has access to open the workbook?

 

[RoryA]

As security goes, that would be fairly rubbish, in all honesty. Can't you put the file somewhere that only certain users have network access to? It would be a lot safer.

 

[Robert_Conklin]

I can for one of the files, but the other is a financial document that only certain people are privy to. That file is emailed to them, but the added security would be nice.

 

[RoryA]

You can use Environ("username") to get the login ID, but simply disabling macros would defeat that.

 

[Robert_Conklin]

Gotcha, thanks for your time.