Worksheet Function not refreshing

[Guest]

I have a excel file which is used by several people and I wanted it to show
who was using it at the moment so I wrote

Public Function CurrUserName(Workbook) As String
CurrUserName = Application.UserName
End Function

This does work but is only updated when someone clicks inside the cell and
then hits return.

How Can I get this to autommatically recalculate whenever someone opens the
file.

 

[Fredrik Wahlgren]

I have a excel file which is used by several people and I wanted it to show
who was using it at the moment so I wrote

Public Function CurrUserName(Workbook) As String
CurrUserName = Application.UserName
End Function

This does work but is only updated when someone clicks inside the cell and
then hits return.

How Can I get this to autommatically recalculate whenever someone opens the
file.

You need to use Appplication.Volatile

Public Function CurrUserName(Workbook) As String
Application.Volatile True
CurrUserName = Application.UserName
End Function

/Fredrik