Disable Vba Excel View Mode

Asked

Viewed 335 times

0

inserir a descrição da imagem aqui

How to Disable Display Mode by Vba Excel.

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

2 answers

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

0

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

inserir a descrição da imagem aqui

  • Hi, thanks, I wanted to do this, but by VBA, without the user intern

Browser other questions tagged

You are not signed in. Login or sign up in order to post.