Cell automatically updates with current user

[phbryan]

I want to have a cell the current user of a workbook automatically
Im using this code

Please Login or Register  to view this content.

And calling the function using =UserName()
The problem is the function doesn't automatically update when a new user opens the file. The new user has to recalculate the =UserName() function to display their name. What am i doing wrong?

[LordLoki]

If u use a UDF it does not calculate on cell update best way to make sure it updates on workbook open is to put this in "thisworkbook"

Please Login or Register  to view this content.