Question : enable macros on opening workbook vba
Answered by : s3ns4
Application.AutomationSecurity = msoAutomationSecurityForceDisable Workbooks.Open Filename:=strFilepath & strFilename, ReadOnly:=True Application.AutomationSecurity = msoAutomationSecurityByUI
Source : https://www.mrexcel.com/board/threads/skip-enable-macros-dialogue-box-when-opening-a-file-with-vba.920110/ | Last Update : Wed, 21 Jul 21