Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On occasions, I need to display a single page (of a multiple page
spreadsheet) full-screen without any embellishment. My code for the relevant sheet is appended at the end of this post, with Application.DisplayFullScreen = True and ActiveWindow.DisplayWorkbookTabs = False doing the "work". This almost gives me what I want, except that the top level menu bar (FILE, EDIT, VIEW, INSERT, FORMAT, TOOLS, DATA, WINDOW, HELP) remains - and is needed at all other times. Is there a VBA method to hide this unwanted item? Option Explicit Private Sub Worksheet_Activate() Application.OnKey "{F5}", "TypeF5" ' PREVIOUS QUESTION Application.OnKey "{F6}", "TypeF6" ' NEXT QUESTION Application.DisplayFullScreen = True ActiveWindow.DisplayWorkbookTabs = False End Sub Private Sub Worksheet_Deactivate() Application.OnKey "{F5}" Application.OnKey "{F6}" Application.DisplayFullScreen = False ActiveWindow.DisplayWorkbookTabs = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i hide & unhide menu bar? | Excel Discussion (Misc queries) | |||
Hide bar above menu titles | Excel Discussion (Misc queries) | |||
excel's menu bar | Excel Discussion (Misc queries) | |||
How do I hide the Worksheet menu bar | Excel Worksheet Functions | |||
Truncated font list in Excel's "Insert Symbol" menu selection | Excel Discussion (Misc queries) |