Full Screen view on my template

  • Thread starter Thread starter Juan
  • Start date Start date
J

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
 
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
 
Thank Charles for the codes!!
Charles Maxson said:
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
Click to expand...
 
Back
Top