Hi,
Your code's not right. It should be:
Code:
Sub UnprotectDocuments()
Application.ScreenUpdating = False
Dim strFolder As String, strPwd As String, strFile As String, wdDoc As Document, TrkStatus As Boolean
TrkStatus = Options.WarnBeforeSavingPrintingSendingMarkup
Options.WarnBeforeSavingPrintingSendingMarkup = False
strPwd = InputBox("What is the password?", "File Password")
If strPwd = "" Then Exit Sub
strFolder = GetFolder
If strFolder = "" Then Exit Sub
strFile = Dir(strFolder & "\*.doc", vbNormal)
While strFile <> ""
Set wdDoc = Documents.Open(FileName:=strFolder & "\" & strFile, AddToRecentFiles:=False, _
Visible:=False, PasswordDocument:=strPwd, WritePasswordDocument:=strPwd)
With wdDoc
'.ReadOnlyRecommended = False
.Password = vbNullString
.WritePassword = vbNullString
.Close SaveChanges:=True
End With
strFile = Dir()
Wend
Set wdDoc = Nothing
Options.WarnBeforeSavingPrintingSendingMarkup = TrkStatus
Application.ScreenUpdating = True
End Sub
Function GetFolder() As String
Dim oFolder As Object
GetFolder = ""
Set oFolder = CreateObject("Shell.Application").BrowseForFolder(0, "Choose a folder", 0)
If (Not oFolder Is Nothing) Then GetFolder = oFolder.Items.Item.Path
Set oFolder = Nothing
End Function
Prior to editing, your reply also said 'the files are still being saved showing markups'. That's correct - the modified code doesn't change the document content in any way. In any event, whether you see the markup or final views is simply determined by choosing the appropriate options on the review tab. Nothing done during the above process can control how a document with tracked changes will be viewed later.