Consulting

Results 1 to 5 of 5

Thread: Excel VB "Unprotect" workbook statement

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Excel VB "Unprotect" workbook statement

    I have a current macro that works...opens files, updates, saves, then close. See below.
    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 !!
    Last edited by Aussiebear; 04-19-2023 at 04:26 AM. Reason: Added code tags

Posting Permissions

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