"LASTSAVED()" does not work for only worksheet.

[rogrand]

I am using "=LastSaved()" that tells me when any change in the workbook.

I like to only record change on a specific sheet. Instead its giveing me changes made when data is enter in any other sheets on the workbook.

Function LastSaved()
Application.Volatile
LastSaved = FileDateTime(ActiveWorkbook.FullName)
End Function

[Keebellah]

Well, the function LastSaved refers to a workbook not a worksheet

The only way to achieve this is to use a worksheet change event that when a value is changed it records it in worksheet that you have explicitly added to track the changes

If you Google this you'll find many ideas, one link that might point you in the right direction https://www.ozgrid.com/VBA/track-changes.htm

Happy coding