Full Screen Mode

[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

 

[steve]

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.