I have this code to show the last time my work book was updated :
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheet1.Range("I56").Value = DateTime.Now
End Sub
I would like to use this same idea to apply the function to each work sheet in the work book. Can someone help me with the code and I assume I will put "that" code into each work sheet in the VBA editor ?
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheet1.Range("I56").Value = DateTime.Now
End Sub
I would like to use this same idea to apply the function to each work sheet in the work book. Can someone help me with the code and I assume I will put "that" code into each work sheet in the VBA editor ?