![]() |
#4
|
||||
|
||||
![]()
It appears the code I provided would only remove forms protection, not the open/write protection. Try the following instead:
Code:
Sub UnprotectDocuments() Application.ScreenUpdating = False Dim strFolder As String, strPwd As String, strFile As String, wdDoc As Document 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 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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
password, protection, remove |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Did an auto-update remove password protection? | namedujour | Excel | 0 | 11-22-2011 07:40 AM |
Password Protection Problem | todobfl | Excel | 4 | 07-26-2011 06:40 PM |
![]() |
JimP | Visio | 2 | 03-24-2011 04:23 AM |
Help reg Protection of cell. | aligahk06 | Excel | 1 | 09-02-2009 05:45 PM |
Visio - password protection | icap5183 | Visio | 0 | 07-24-2009 06:00 AM |