Excel VB "Unprotect" workbook statement

I have a current macro that works...opens files, updates, saves, then close. See below.

Code:

---

Sub TestUpdate()
Workbooks.Open Filename: = V:\user folder\filename.xls, updatelink:=3
ActiveWorkbook.Save
ActiveWindow.Close
End Sub

---

We are having issues with the Protected view prompt, enable editing. This stops our macros, and we run through about 25 files with this current macro. How do I add the VB "Unprotect" statement that will turn this off on every file when it is opened, before the update begins?

Thank you for your help !!

Try this

Code:

---

Sub UnProtectingWorkbooks()
Const Passwurd As String = "???"

Workbooks.Open Filename: = "V:\user folder\filename.xls", updatelink:=0
With ActiveWorkbook
  .UnProtect Passwurd 'If PAssword needed
  .updatelinks
  .Save
  .Protect Passwurd 'If PAssword needed
  .Close
End With
End Sub

---

I keep getting a run-time error 424, object required.

Also, this is not password protected, but files open in protected view, enable editing.

TRY this to see if it works for you (Excel 2016)

Excel Options

Trust Center

Trust Center Settings

Protected View

and uncheck the three boxes

Attachment 21936