| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I track users who access a spreadsheet? | Excel Discussion (Misc queries) | |||
| "Track Changes" - Prevent turn off track changes to meet SOX regs | Excel Discussion (Misc queries) | |||
| I want to download MS Access template for Customer complain track | Excel Programming | |||
| How do I set up and track data in Excel or Access? | Setting up and Configuration of Excel | |||
| keeping track of a range of cells in another spreadsheet or access database | Excel Programming | |||
Hybrid Mode
