Techgirl7
03-27-2018, 07:42 AM
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 !!
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 !!