Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Function not refreshing
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. -- Cheers Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Function not refreshing
"Mark" wrote in message ... 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. -- Cheers Mark You need to use Appplication.Volatile Public Function CurrUserName(Workbook) As String Application.Volatile True CurrUserName = Application.UserName End Function /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function Values Not Refreshing | Excel Worksheet Functions | |||
refreshing or repainting worksheet | Excel Programming | |||
refreshing custom function | Excel Programming | |||
Refreshing a Worksheet | Excel Programming | |||
Refreshing a Worksheet | Excel Programming |