/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 vote128 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote120 views1 answer
Vba open report
VBA
5 votes144 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote132 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote111 views1 answer
Vba dropdown event
VBA
0 vote132 views1 answer
Add text to combobox drop down vb
VBA
0 vote119 views1 answer
Add items to combobox vb.net
VBA
0 vote122 views1 answer
Vbscript for loop
VBA
0 vote121 views1 answer
Vbs
VBA
3 votes130 views1 answer
Vba post request json
VBA