Full Screen view on my template

[Juan]

How can I get a certain template to open up with a Full Screen view eac
time that it opens. And yet maintain the regular view whenever I ope
Excel without that particular template? Hel

 

[Charles Maxson]

Juan

In VBA, add this code to the ThisWorkbook class of your template:


Private Sub Workbook_Activate()
Application.DisplayFullScreen = True
End Sub

Private Sub Workbook_Deactivate()
Application.DisplayFullScreen = False
End Sub

 

[Adam Familia]

Thank Charles for the codes!!

Juan

In VBA, add this code to the ThisWorkbook class of your template:


Private Sub Workbook_Activate()
Application.DisplayFullScreen = True
End Sub

Private Sub Workbook_Deactivate()
Application.DisplayFullScreen = False
End Sub