Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I can only see spreadsheet in 'full screen' mode? | Excel Discussion (Misc queries) | |||
how to disable automatic full screen mode? | Excel Discussion (Misc queries) | |||
Excel workbook contents only visible in Full Screen mode ... | Excel Discussion (Misc queries) | |||
full screen mode | Excel Discussion (Misc queries) | |||
Disable right mouse click when in Full screen mode | Excel Discussion (Misc queries) |