Bruno Capelli
24-11-2015 15:08:51
Pessoal estou usando o seguinte código para exibir o excel em modo cheio porém se sair da tela seja por minimizar ou alt tab ele perde a função gostaria que ele só voltasse se eu desse o comando, podem me ajudar?
Grato!
Private Sub Workbook_Open()
With Application
.DisplayFormulaBar = False
.DisplayAlerts = False
.DisplayFullScreen = True
.DisplayStatusBar = False
End With
With ActiveWindow
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
.DisplayGridlines = False
End With
End Sub
Private Sub Workbook_Deactivate()
With Application
.DisplayAlerts = True
.DisplayFormulaBar = True
.DisplayFullScreen = False
.DisplayStatusBar = True
End With
With ActiveWindow
.DisplayHeadings = True
.DisplayHorizontalScrollBar = True
.DisplayVerticalScrollBar = True
.DisplayWorkbookTabs = True
.DisplayGridlines = True
End With
End Sub
Grato!
Private Sub Workbook_Open()
With Application
.DisplayFormulaBar = False
.DisplayAlerts = False
.DisplayFullScreen = True
.DisplayStatusBar = False
End With
With ActiveWindow
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
.DisplayGridlines = False
End With
End Sub
Private Sub Workbook_Deactivate()
With Application
.DisplayAlerts = True
.DisplayFormulaBar = True
.DisplayFullScreen = False
.DisplayStatusBar = True
End With
With ActiveWindow
.DisplayHeadings = True
.DisplayHorizontalScrollBar = True
.DisplayVerticalScrollBar = True
.DisplayWorkbookTabs = True
.DisplayGridlines = True
End With
End Sub