usernames

Hi all, I'm really struggling to have a cell pre-populate with the users full name. The only code I can find, returns the users employee number. See below: Worksheets("test").Range("g9").Value = Environ("username") My workaround was to use this function: Function UserNames() As String...

I have a workbook that I only want certain users to be able to open. I have a list of network usernames that should have access on a worksheet called "LISTS". The list of usernames is in column "M" (range M2:M159) that has a dataname of "usernames". How do I set up some VBA code to look at...

Hello all, I could use some help here. I need a code that can allow the cell to autocreate a note where the name of the user who enteres data will be automatically filled in. Is there any way to accomplish?? Thanks in advance.

Hello All, here is my excel problem. Smith, John Doe, Jane Smithss, Jack Whitess, John Blackss, Jane Bluesss, Peter Longlastname, Phillip I dont know if it's possible to have these converted to usernames. The format is 6/1 (first 6 character of last name and 1st character of first name) of...

Hi All: I found this code to open workbook if only name Array the same Username of PC: Private Sub Workbook_Open() Dim UserNames As Variant UserNames = Array("Username1", "Username2", "Username3") If Not IsNumeric(Application.Match(Application.UserName, UserNames, 0)) Then MsgBox "You...