Company policy has changed and i think it has to do with protected view.
I used to gather excel files in a folder, open de files and get some info out with a loop.
I am getting a Run-timer when opening, i have tried "EnableEvents" but this wont do anything the runtimer still pops up.
Is there anyway to avoid or disable this Protected View warning?
Do Until Sheet42.Cells(1, 4) = "x"
Application.EnableEvents = False
FName = Sheet42.Cells(1, 4)
Set WbData = Application.Workbooks.Open(Filename:=(FName)) 'open file
WbMacro.Sheets("Macro2").Cells(3, 3) = "Processing; " & WbData.Name
Application.StatusBar = "Process Entity: " & WbData.Name 'process bar
Bookmarks