application.username

The format of Application.UserName for people at my company is "Last, First". As a result, I've written a few lines that translate this to "First Last" and called it "FirstLast". I've used FirstLast throughout my code, but I'm now using the sheet with folks at another company whose UserName is...

I'm using the following to convert Application.Username which is formatted "Last, First" to "First Last". For my name, it is working, but for a colleague it is not. I am baffled. The result for my colleague is "h, John Smith". I have had her select all and retype it, and it's still not working...

Hi, I have the following code to catalog worksheet changes. I've added a crude shell of an If And statement to have it check to see if there is a previous item in the table in which the same User has made an edit on the current date. The goal is that only one entry is made for an individual...

Hi all - thanks in advance for your consideration. I first posed this question yesterday and got a great solution from @Yongle, but I've progressed my needs so have posted a new thread. I'm designing a workbook to update the way my team provides monthly updates to the boss - a shared workbook...

Hi Current code; Private Sub Workbook_Open() Dim sh As Worksheet For Each sh In Worksheets sh.Visible = True Next Dim sht As Worksheet If Application.UserName = "Name 1", "Name 2", "Name 3" Then Exit Sub For Each sht In ThisWorkbook.Sheets If sht.Name <>...

Hi, I need your help with following task. I have shared file, for which few users have special right and can modify the data inside it. It works this way that Workbook_open recognise who is opening it by USERNAME and give special permisses or opening as read only. But I would like to modify...

Hi all, I'm building a userform, and I want to include application.username in label1.caption I tried several codes but none has succeeded to show the username, I believe the most logic thing to do is to load the label caption when the userform loads, using this code, but it didn't work...

Hi all, I'm building a userform, and I want to include application.username in label1.caption I tried several codes but none has succeeded to show the username, I believe the most logic thing to do is to load the label caption when the userform loads, using this code, but it didn't work...

Hi, Application.Username and environ("Username") gives different values in excel 2007 But it does not in 2003. Both gives environ("Username").value. Please help me how to figure this out in excel 2003. Thanks. Pedie;)