/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

27 votes291 views2 answers
Vba check if file exists
VBA
0 vote158 views1 answer
Rotate image by any angle vb.net
VBA
0 vote159 views1 answer
Vba get application version
VBA
0 vote156 views1 answer
Get current url vb.net
VBA
3 votes169 views1 answer
Vba double quote
VBA
0 vote145 views2 answers
Excel vba prevent save
VBA
0 vote194 views1 answer
Vbnet add axis labels to chart
VBA
4 votes158 views2 answers
Vba create folder if not exist
VBA
31 votes275 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote111 views1 answer
Excel vba arrondir
VBA