View Single Post
  #2   Report Post  
 
Posts: n/a
Default

not that i know of but you can do it with code. here is
some code we use in some of our files to keep a record of
who opened a file, when and how long they were in it.
to add code: alt+F11. copy and paste this code in the this
work book module. the code wrapped when i pasted it here.
it should be 4 lines each sub with each line starting with
sheetes. otherwise you made get errors.

Private Sub Workbook_BeforeClose(Cancel As Boolean)

Sheets("Formula").Range("IT2").End(xlDown).Offset( 1,
0).FormulaR1C1 = Now()
Sheets("Formula").Range("IT2").End(xlDown).Offset( 1,
0).Copy
Sheets("Formula").Range("IT2").End(xlDown).Offset( 1,
0).PasteSpecial Paste:=xlValues
Sheets("Formula").Range("IT2").End(xlDown).Offset( 0,
1).FormulaR1C1 = Application.UserName

End Sub
Private Sub Workbook_Open()

Sheets("Formula").Range("IQ2").End(xlDown).Offset( 1,
0).FormulaR1C1 = Now()
Sheets("Formula").Range("IQ2").End(xlDown).Offset( 1,
0).Copy
Sheets("Formula").Range("IQ2").End(xlDown).Offset( 1,
0).PasteSpecial Paste:=xlValues
Sheets("Formula").Range("IQ2").End(xlDown).Offset( 0,
1).FormulaR1C1 = Application.UserName

End Sub

-----Original Message-----
I am aware of functions like =TODAY() which will

automatically insert today's
date into a cell. I was wondering if something similar

existed for user
ID's/name. When you create a new spreadsheet it bears

the name of the user
who first created it in the properties. Is there a

function I can put in a
cell that will show the user name/id who has opened or

last mondified the
file (for example)? Thanks.
.