I have a number of summary reports that are updated by the use of a macro update button.

I usually include an area on the report to include a datestamp that indicates when the report was last updated or refreshed.

This is the code I use:

Dim VERSIONDATE As String VERSIONDATE = Format(Now, "dd-mm-yy hh-mm-ss") Range("B3").Value = VERSIONDATE