View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default 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