Last date modified

[Johfra]

I am creating a spreadsheet with 33 tabs. Each tab represents individual departments.

Each will have data modified at different times and I would like the last date modified to be seen on the spreadsheet. This workbook will be used amongst several people and we need to know when it was last modified to avoid confusion.

Thank you!

[gyclone]

There is a "Worksheet_Change" event that fires when a worksheet is changed. You can use that, in combination with "Now()" to capture the date modified. More information here: http://www.ozgrid.com/VBA/run-macros-change.htm and here: http://msdn.microsoft.com/en-us/libr.../ff839775.aspx