Environ("username") doesn't seem to work

[jmpatrick]

Happy rainy Monday!

I have the following code to run macros based on the user's name. By stepping through the Workbook_Open code on a couple machines with different users I have verified that it's not detecting the user's name at all. I'm not getting any errors but I must be doing something wrong. If it matters, all users are using Windows 10 Pro. Here's the code (All names have been changed to protect the innocent):

Private Sub Workbook_Open()

  Application.Calculation = xlAutomatic

  Call SortByDate
 
  If Environ("username") = "User1" Then
  
  Call ViewJP
 
  Application.MoveAfterReturnDirection = xlToRight
 
  GoTo SkipDashboard
      
  ElseIf Environ("username") = "User2" Then
 
  Call ViewALR
 
  Application.MoveAfterReturnDirection = xlToRight
 
  GoTo SkipDashboard
 
  ElseIf Environ("username") = "User3" Then
 
  Call ViewALR
 
  Application.MoveAfterReturnDirection = xlToRight
 
  GoTo SkipDashboard
 
  ElseIf Environ("username") = "User4" Then
 
  Call ViewALR
 
  Application.MoveAfterReturnDirection = xlDown
 
  GoTo SkipDashboard
 
  ElseIf Environ("username") = "User5" Then
 
  Call ViewALR
 
  Application.MoveAfterReturnDirection = xlToRight
 
  GoTo SkipDashboard
 
  End If
 
  Call OpenDashboard
 
SkipDashboard:
 
End Sub

 

[jmpatrick]

Perhaps Environ("username") refers to the Office (Excel) username and not the Windows username? I'm trying to use the Excel username.

 

[Fluff]

The Environ("username") is the Windows login name, if you want the Excel username you need to use Application.Username

 

[jmpatrick]

The Environ("username") is the Windows login name, if you want the Excel username you need to use Application.Username

I just stumbled on that and came back to post. Works great. Thanks!