Can I pgrogramatically access Track Changes?

[Guest]

When a workbook is shared one has the option to view the changes that various
users have made. Is there any way to programatically access those changes>

Thanks,

Russ

 

[Guest]

I have never tried it, but as I recall, the changes are stored in a hidden
sheet named HISTORY. You might see if such a sheet exist and see what it
looks like. That could be accessed programmatically.

 

[Guest]

Thanks Tom. I'll check it out.

I have never tried it, but as I recall, the changes are stored in a hidden
sheet named HISTORY. You might see if such a sheet exist and see what it
looks like. That could be accessed programmatically.

 

[Guest]

Russ,

This code will generate the History sheet that Tom mentioned. When you save
the workbook, it seems Excel automatically deletes the History sheet. But I
guess you can just always re-generate the History Sheet whenever you need it.


Sub ShowHistory
ActiveWorkbook.ListChangesOnNewSheet = True
End Sub

 

[Guest]

That's handy. thanks Vergel.

Russ,

This code will generate the History sheet that Tom mentioned. When you save
the workbook, it seems Excel automatically deletes the History sheet. But I
guess you can just always re-generate the History Sheet whenever you need it.


Sub ShowHistory
ActiveWorkbook.ListChangesOnNewSheet = True
End Sub