Run VBscript on Workbook change

[julesm07]

Hi,

I have found a number of posts on how to run a script when a cell or even a worksheet changes, but what about a workbook?

I have a 12 sheet workbook, and would like the below script to run any time a cell in the workbook is changed. Is that possible?

TIA for any help!


Function LastModified() As Date

LastModified = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")

End Function

 

[Joe4]

Welcome to the Board!

It appears that the "Workbook_SheetChange" event procedure (found in the "ThisWokbook" module) is what you are after.
See: Workbook.SheetChange event (Excel)