Filter by User ID
 

I have a task spreadsheet that needs to be updated by many users. The
spreadsheet is in shared mode.

How do I get the spreadsheet to automatically filter by the user Id on
opening the file?

I had thought of using a lookup table but cannot figure out how to capture
the information in the "User Name" field in the Options | General tab.

Filter by User ID
 

This tiny UDF will give you the name of the current user:

Public Function UserName2() As String
UserName2 = Environ("UserName")
End Function


--
Gary''s Student - gsnu200758


"Nelson Mather" wrote:

I have a task spreadsheet that needs to be updated by many users. The
spreadsheet is in shared mode.

How do I get the spreadsheet to automatically filter by the user Id on
opening the file?

I had thought of using a lookup table but cannot figure out how to capture
the information in the "User Name" field in the Options | General tab.