Results 1 to 10 of 10
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Track Changes (2003/SP2)

    Does anyone know of an add-on or technique that will track changes in Excel in a similar approach to that used in Word?

    If you manage to surprise me, it will be a pleasant surprise.

    T.I.A.
    Regards
    Don

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Track Changes (2003/SP2)

    Excel does have a Track Changes feature (Tools | Track Changes | Track Changes), but unfortunately it forces you to make the workbook shared, which is widely seen as a potential cause of workbook corruption. However, as long as only one person edits the workbook at a time, it should be OK.
    Like in Word, you can later accept or reject specific changes, through Tools | Track Changes | Accept or Reject Changes.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Track Changes (2003/SP2)

    In addition to Hans' comment about the pothential corruption, many features of excel are disabled when the workbook is shared

    Steve

  4. #4
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Track Changes (2003/SP2)

    Thank you Hans and Steve
    I took someone's word for something without a thorough test of validity. Once again: The Lounge to the rescue!
    Regards
    Don

  5. #5
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Track Changes (2003/SP2)

    Thanks for the reply Hans
    I can find no method of enabling/disabling the Track Changes feature with VBA code. Is it possible?
    Regards
    Don

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Track Changes (2003/SP2)

    I can't find anything relevant. I think a workbook has to be closed and reopened to turn track changes on or off (if you watch closely while doing this interactively, you may notice this). This would explain why it can't be done in code.

    You can, however, accept or reject changes: the Workbook object has AcceptAllChanges and RejectAllChanges methods.

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Track Changes (2003/SP2)

    Try something like this:
    <pre>Sub TrackChanges()
    With ActiveWorkbook
    .ProtectSharing
    .KeepChangeHistory = True
    .HighlightChangesOptions _
    When:=xlSinceMyLastSave, _
    Who:="Everyone"
    .ListChangesOnNewSheet = True
    End With
    End Sub
    </pre>


    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Track Changes (2003/SP2)

    I had missed that! Good catch! <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  9. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Track Changes (2003/SP2)

    Thanks - took a bit of rummaging in the Object Browser to find! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  10. #10
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Track Changes (2003/SP2)

    Hans and Rory
    I stand in absolute awe of you gentlemen. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15> <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    Thank you.
    Regards
    Don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •