Hi,
The code below opens a workbook on our sharepoint site. The "Application.EnableEvents = False" bypasses the "Open / Cancel" request that appears at the bottom of the IE 11 but then the Downloads Box appears where you need to click open. How can you open the workbook and suppress the various open requests?
Sub OpenHyperlink()
Application.EnableEvents = False 'disable Events
ActiveWorkbook.FollowHyperlink Address:=Range("C2")
Application.EnableEvents = True 're-enable Events
End Sub
The code below opens a workbook on our sharepoint site. The "Application.EnableEvents = False" bypasses the "Open / Cancel" request that appears at the bottom of the IE 11 but then the Downloads Box appears where you need to click open. How can you open the workbook and suppress the various open requests?
Sub OpenHyperlink()
Application.EnableEvents = False 'disable Events
ActiveWorkbook.FollowHyperlink Address:=Range("C2")
Application.EnableEvents = True 're-enable Events
End Sub