Can I pgrogramatically access Track Changes?
 

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

Can I pgrogramatically access Track Changes?
 

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.

--
Regards,
Tom Ogilvy


"xrbbaker" wrote:

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

Can I pgrogramatically access Track Changes?
 

Thanks Tom. I'll check it out.

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy


"xrbbaker" wrote:

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

Can I pgrogramatically access Track Changes?
 

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


--
Hope that helps.

Vergel Adriano


"xrbbaker" wrote:

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

Can I pgrogramatically access Track Changes?
 

That's handy. thanks Vergel.

"Vergel Adriano" wrote:

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


--
Hope that helps.

Vergel Adriano


"xrbbaker" wrote:

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