Thanseef M S
New Member
- Joined
- Apr 16, 2023
- Messages
- 3
- Office Version
- 2019
- Platform
- Windows
how to generate Last Modified Date & Last Modified Time in a cell
in a specified cell like this...Do you want this to be the exact time that you made the last change to any cell in each worksheet in the workbook, the last time that you made any change to any cell in any worksheet in the workbook or the last time that the workbook was saved?
Last Modified Date | answer |
Last Modified Time | answer |
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Worksheets("datetimelog").Range("B1:B2").Calculate
End Sub