Macro security via Windows login name (or other)

[Neil]

Hi All,

Is there a way that I can limit access to a macro via the windows login name
?

For example, something along the lines of 'if windows login user name = Neil
then continue executing macro, else flash an error message and stop.

Any ideas ?

Thanks everyone.

Neil

 

[Jim Rech]

Sub a()
If Environ("username") = "Neil" Then
MsgBox "OK"
Else
MsgBox "Not OK"
End If
End Sub


--
Jim
| Hi All,
|
| Is there a way that I can limit access to a macro via the windows login
name
| ?
|
| For example, something along the lines of 'if windows login user name =
Neil
| then continue executing macro, else flash an error message and stop.
|
| Any ideas ?
|
| Thanks everyone.
|
| Neil
|
|

 

[Neil]

Excellent,

Thanks Jim...

Neil