have a shared group file and would like to see upon opening the last date a
change was made to the file. Thanks.
have a shared group file and would like to see upon opening the last date a
change was made to the file. Thanks.
I don't think there's a regular Excel worksheet function to give you that
information, but you can create a User Defined Function to do it.
Use the VB Editor ([Alt]+[F11] to get into it, Insert | module to insert a
new code module if required - otherwise just add to existing code module)
Put this code in there
Function GetModifiedDate(Dummy As Variant)
GetModifiedDate = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
End Function
Now back on the worksheet where you want to show that, use it like you would
any other function in Excel. Lets say you want the date to show up in cell
A2 on a sheet, then in that location put
=GetModifiedDate(A2)
yes, not a mistake, the cell is going to reference itself. It's just a
dummy value that isn't used by the function itself. But worksheet functions
seem to have a deep seated need for at least one parameter. Format the cell
as Date in to be displayed however you want, and you're in business.
"teh_chucksta" wrote:
> have a shared group file and would like to see upon opening the last date a
> change was made to the file. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks