Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-08-2012, 07:03 AM
EZRider EZRider is offline Macro to accept deleted insertions - Help Windows 2K Macro to accept deleted insertions - Help Office 2003
Novice
Macro to accept deleted insertions - Help
 
Join Date: Jul 2009
Posts: 6
EZRider is on a distinguished road
Default Macro to accept deleted insertions - Help

I have several word documents where multiple users were working on edits with track changes on. The issue that I'm having is that when a user deletes the insertions of another user, rather than removing all traces of the insertion it leaves the insertion and shows it as "strikethrough".



For an outsider reviewing the document it appears that the insertion was original text that we chose to delete.

Is there a macro that would go through the document and accept all changes that meet this criteria (inserted from one user then deleted from another)?
Reply With Quote
  #2  
Old 06-11-2012, 05:09 AM
macropod's Avatar
macropod macropod is offline Macro to accept deleted insertions - Help Windows 7 64bit Macro to accept deleted insertions - Help Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

AFAIK, that's not possible.

When a reviewer replaces someone else's outstanding revision with their own (eg by overtyping a deletion or deleting an addition), Word only tracks the last action - it keeps no record of the previous outstanding revision.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 06-12-2012, 08:37 AM
EZRider EZRider is offline Macro to accept deleted insertions - Help Windows 2K Macro to accept deleted insertions - Help Office 2003
Novice
Macro to accept deleted insertions - Help
 
Join Date: Jul 2009
Posts: 6
EZRider is on a distinguished road
Smile Solution

Thanks Macropod but Word will, with track changes on, keep a record of both changes.

I did manage to solve the issue I was having. If anyone is interested here is the code:

Code:
Sub StrikethroughDeletions() 
     'Turn off Track Changes
    ActiveDocument.TrackRevisions = Not ActiveDocument.TrackRevisions 
     'Highlight revisions of type deletion
    Number = ActiveDocument.Revisions.Count 
    For x = 1 To Number 
        Set myRev = ActiveDocument.Revisions(x).Range 
        This = ActiveDocument.Revisions(x).Type 
        If This = 2 Then 
            myRev.HighlightColorIndex = wdYellow 
        End If 
    Next x 
     ' For all highlighted text, underline and strikethrough if also inserted
    For Y = 1 To Number 
        Set myRev = ActiveDocument.Revisions(Y).Range 
        That = ActiveDocument.Revisions(Y).Type 
        If That = 1 Then 
            myRev.Select 
            If Selection.Range.HighlightColorIndex = wdYellow Then 
                Selection.Font.Underline = True 
                Selection.Font.StrikeThrough = True 
            End If 
        End If 
    Next Y 
     'This will then find and remove the deleted insertions
    Selection.Find.ClearFormatting 
    With Selection.Find.Font 
        .Underline = wdUnderlineSingle 
        .StrikeThrough = True 
        .DoubleStrikeThrough = False 
    End With 
    With Selection.Find 
        .Text = "" 
        .Replacement.Text = "" 
        .Forward = True 
        .Wrap = wdFindContinue 
        .Format = True 
        .MatchCase = False 
        .MatchWholeWord = False 
        .MatchWildcards = False 
        .MatchSoundsLike = False 
        .MatchAllWordForms = False 
    End With 
    Selection.Find.Execute Replace:=wdReplaceAll 
     
     'This will now delete all highlighting
    Dim rngDoc As Range 
    Set rngDoc = ActiveDocument.Range(Start:=0, End:=0) 
    With rngDoc.Find 
        .ClearFormatting 
        .Highlight = True 
        With .Replacement 
            .ClearFormatting 
            .Highlight = False 
        End With 
        .Execute Replace:=wdReplaceAll, Forward:=True, FindText:="", _ 
        ReplaceWith:="", Format:=True 
    End With 
     
     'Turn on track changes
    ActiveDocument.TrackRevisions = Not ActiveDocument.TrackRevisions 
End Sub
Thanks all
Reply With Quote
  #4  
Old 08-19-2013, 03:40 PM
Alphacsulb Alphacsulb is offline Macro to accept deleted insertions - Help Windows 7 64bit Macro to accept deleted insertions - Help Office 2010 32bit
Novice
 
Join Date: Aug 2013
Posts: 2
Alphacsulb is on a distinguished road
Default

Thank you for posting that code, I was able to use part of it for my work flow.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to accept deleted insertions - Help Accept all changes then resave cure4glass Word VBA 1 03-08-2012 10:04 PM
Macro to accept deleted insertions - Help accept grammar errors Newbe1 Word 3 12-23-2010 03:05 PM
How to Set Password to Accept Changes kurobenko Word 1 05-12-2010 02:54 AM
MS Word 2007 - Product Key Not Accept Ramesh Office 0 02-18-2010 02:14 PM
Unable to Accept / Decline Appointments Sent to Me - HELP! FrUtopia27 Outlook 0 04-16-2007 03:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft