Saved By and Date...

[Legacy 102501]

Hi there<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have 'lots' of workbooks that are constantly being updated by various people. Over the top of these workbooks I have one summary spreadsheet that pulls data from the workbooks and has two fields that should state who last saved the various workbooks and when it was saved to enable me to monitor who has been updating their forecasts.<o></o>
<o></o>
I was going to do the date by '=NOW()' in each workbook and link it back to the summary workbook, but i can't work out how to do the user... and not sure =NOW() is the best why to do the date either.<o></o>
<o></o>
Any suggestions?<o></o>
<o></o>
Thanks in advance

M<o></o>

 

[Makrini]

You could create this UDF

Function theuser()
    theuser = Environ("username")
End Function

then put in a cell.. =theuser() & " " & Now()