Thread: Changes History

Is there a way of creating a chart that monitors events that numerous people can change and input data? These changes to be monitored then displayed, either in a list or graph format? Also, although this work book/sheet can be changed by many people, these changes will create an history which can be saved but not altered, only by the owner of this workbook. (Excel 2007)

I have a similar issue.

I would like Excel to automatically track all changes since the last time I opened the file, and have it present it in the new sheet. I am able to this manually, but I would like it to do this automatically once I open the worksheet. Is this possible?

Have a play with this code

Sub Jack_in_the_UK_TRACK_CHANGES()

Dim myWorkBook As Excel.Workbook
Set myWorkBook = ThisWorkbook

With myWorkBook
    .HighlightChangesOptions When:=xlAllChanges
    .ListChangesOnNewSheet = False
    .HighlightChangesOnScreen = True
End With

theEND_Jack_in_the_UK_TRACK_CHANGES:
'// Jack in the UK - do stuff here
Set myWorkBook = Nothing
Exit Sub
End Sub