I've shared a workbook, tracked the changes to a new worksheet, printed the changes, and now I want to save the "history" worksheet that Excel automatically generated. Does anyone know if this is possible.
Thanks so much!
Sydni
I've shared a workbook, tracked the changes to a new worksheet, printed the changes, and now I want to save the "history" worksheet that Excel automatically generated. Does anyone know if this is possible.
Thanks so much!
Sydni
In Tools, TrackChanges, Highlight Changes, is a 'List to Sheet'Originally Posted by smurphy812
this sheet is then a standard Worksheet and you can Edit - Move or Copy etc
hth
---
Si fractum non sit, noli id reficere.
I've done this, but when I save the file the worksheet doesn't save with the file. I have to regenerate the next time the file is opened. Any ideas?
Thanks!
Sydni
Hi,Originally Posted by smurphy812
The 'Track' is rather guarded in allowing access to it's data, one possibility for you is if you record a macro, and replace the code withand in Macro, Options set to a ShortCut key (like Ctrl/Shift/H for 'History') then, with the History in view, press CTRL/SHIFT/H the data will be copied to a new sheet, this sheet will save with the workbook.Sub SaveHistory() Dim iLastRow As Long On Error GoTo AddSheet Sheets("SaveHistory").Select GoTo SaveItems AddSheet: Sheets.add ActiveSheet.Name = "SaveHistory" SaveItems: On Error GoTo ExitSub Sheets("History").Activate iLastRow = ActiveSheet.Range("A65536").End(xlUp).Row Range("A1:K" & iLastRow).Select Selection.Copy Sheets("SaveHistory").Select iLastRow = ActiveSheet.Range("A65536").End(xlUp).Row Cells(iLastRow + 1, 1).Select ActiveSheet.Paste Application.CutCopyMode = False ExitSub: End Sub
Note, you will need to take the workbook off 'Share' to do the macro setup, but it will run as a ShortCut.
Let me know how you go.
---
Bryan,
Thanks for the reply. I think this will work. I've tested breifly and all appeared as it should.
Thanks again!
Sydni
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks