Disable Vba Excel View Mode

Question

How to Disable Display Mode by Vba Excel.

Wanted that when opening the spreadsheet the user already came with this enabled feature

Answer 1

This code of Mr Excel keeps the security status of the spreadsheet in the variable lSecurity, then switches to the low security level msoAutomationSecurityLow and then returns to the original security level.

Public Sub Subrotina()
    Dim lSecurity As Long

    On Error GoTo Fechar

    lSecurity = Application.AutomationSecurity
    Application.AutomationSecurity = msoAutomationSecurityLow

    '''''''''''''''''''''
    '   Código aqui     '
    '''''''''''''''''''''

Fechar:
    Application.AutomationSecurity = lSecurity
End Sub

Answer 2

Only go in the options. File->Options. Adjust in Reliability Center.