/VBA/Enable macros on opening workbook vba

Enable macros on opening workbook vba

    Application.AutomationSecurity = msoAutomationSecurityForceDisable
    Workbooks.Open Filename:=strFilepath & strFilename, ReadOnly:=True
    Application.AutomationSecurity = msoAutomationSecurityByUI

Source: mrexcel.com

Similar codes

0 vote170 views1 answer
Vba nested dictionary
VBA
0 vote161 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote168 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote164 views1 answer
Vba string
VBA
0 vote259 views1 answer
Find the name of the last excel sheet vb
VBA
1 vote173 views1 answer
Vba login website
VBA
3 votes172 views1 answer
Vba make long from two shorts
VBA
0 vote172 views1 answer
Vba array of integers
VBA
15 votes310 views2 answers
Xl vba dynamic string array
VBA
0 vote165 views1 answer
Excel vba scroll to cell
VBA