Excel - Last Modified User in different sheets

[stellalol]

Hi,

I have been trying to make a cell show the last modified user.
I am using this code

Function getLastModifiedUser()
getLastModifiedUser = ActiveWorkbook.BuiltinDocumentProperties("Last Author")
End Funtion

Problem is, I have two sheets that have the same exact format as to the Last Motified User Cells
Could each sheet have a different Last Modified User name? Is that possible?

Thanks in advance guys!

 

[CephasOz]

Hi stellalol. The only way that the date would show as blank is if the code to set the date wasn't in that sheet. So, in every sheet that you want record last user and last date, you need to have the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
    SetVar "LU_" & Me.Name, Env_UserName()
    SetVar "LU_" & Me.Name & "_Date", Format(Date, "Short Date")
End Sub

The first SetVar saves the user name, the second SetVar saves the date, so they both need to be there.

 

[stellalol]

Hi stellalol. The only way that the date would show as blank is if the code to set the date wasn't in that sheet. So, in every sheet that you want record last user and last date, you need to have the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
    SetVar "LU_" & Me.Name, Env_UserName()
    SetVar "LU_" & Me.Name & "_Date", Format(Date, "Short Date")
End Sub

The first SetVar saves the user name, the second SetVar saves the date, so they both need to be there.

Yes!! You are right!!! I had forgotten to add the code that has the date! You were very helpful @CephasOz !
Many thanks!

 

[CephasOz]

Glad to help.