Insert date for last workSHEET modification

[bethanj93]

Hi,

I have found codes which work for giving the date the workbook was last modified by using the 'last saved' date. However I could really do with a formula or vba which returns the date/time a single sheet was last modified. I think it will also be more complicated because the only thing that will be being edited is a smartart heirachy.

Any ideas?

[:) Sixthsense :)]

As far as I know it's not possible to do that using excel's inbuilt worksheet functions

[bethanj93]

I thought as much smart art is proving a right pain!

Thanks anyway

[kvsrinivasamurthy]

Worksheet_change event is used for Sheet1.
When any changes are made in sheet Time is recorded.

[bethanj93]

Thanks so much - tried that code but it doesnt seem to change for smart art modifications ... only cell mods