Worksheet Properties - Last User

[John Calder]

Hi

The PC I use is part of an network that requires individuals to log on with
their own personal log-on. ie: QWCAL when starting the computer.

What is would like is some VB that would return the log-in of the last
person to save the file.

Any help is much appreciated

John

 

[Gord Dibben]

John

Private Sub Workbook_BeforeSave(ByVal SaveAsUI _
As Boolean, Cancel As Boolean)
With ThisWorkbook
With Worksheets("Sheet1")
.Range("A1").Value = "Last Saved By " _
& Environ("UserName") & " " & Now
End With
End With
End Sub


Gord Dibben MS Excel MVP