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!
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!