Full Screen Mode

  • Thread starter Thread starter Hatzipavlis Stratos
  • Start date Start date
H

Hatzipavlis Stratos

While i have more than 1 excel workbooks open i'd like
only one of them to work in full screen mode.
When i change to another workbook i'd like to appear on normal mode with
taskbars and everything.
I also want this workbook operating only in full mode which should only
change via vba so
nobody can change it but me.

Do i want that much?

Thanx
 
Go to the VBE and select the ThisWorkbookModule.
Paste in this code:

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

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

This will toggle when the workbook is activated and deactivated.
 
Back
Top