On Aug 3, 10:46 am, wagz wrote:
I need code that will check the network username and unprotect a worksheet
when the workbook opens. So on open it will check the username and then
unlock the worksheets if it matches a list of approved users. If not, it
will remain locked.

I am using excel 2007.

Thanks for all the help in advance.

Environ("Username") will return the name of the user. You could use
that to validate against a source of your choosing.