Full Screen Mode
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.
--
sb
"Hatzipavlis Stratos" wrote in message
...
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
|