can you trigger a macro based on which user opened the file?

[kskinne]

I have a macro that is triggered when the workbook is opened, and was wondering if it is possible through vba code to determine the windows/network username of the person who opened the file in order to prevent the macro from executing unless it is a particular user?

thanks in advance,
kevin
This message was edited by kskinne on 2002-10-29 09:58

 

[zacemmel]

Private Sub Workbook_Open()
If Application.UserName = "user" Then
code here
End If
End Sub

 

[kskinne]

thanks!