I would like to enter the name of the last person to modify a document into a
specific cell so that when I look at it I can see who last changed the
document.
Is this even possibe?
I would like to enter the name of the last person to modify a document into a
specific cell so that when I look at it I can see who last changed the
document.
Is this even possibe?
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").Range("A1").Value = Date & " " & Time
Sheets("Sheet1").Range("A2").Value = Environ("username")
End Sub
"thudson" wrote:
> I would like to enter the name of the last person to modify a document into a
> specific cell so that when I look at it I can see who last changed the
> document.
>
> Is this even possibe?
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").Range("A1").Value = Date & " " & Time
Sheets("Sheet1").Range("A2").Value = Environ("username")
End Sub
"thudson" wrote:
> I would like to enter the name of the last person to modify a document into a
> specific cell so that when I look at it I can see who last changed the
> document.
>
> Is this even possibe?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks