Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi - i need to be able to hide the ribbon and formula bar in excel upon
opening the file, and undo these while closing it....i place the below code in This Workbook...and it works fine....however i also loose the "Office Button" with the code below... i need to know what i need to include to the below code to allow the Office Button(required for saving the file) to be include but still hide the ribbon and formula bar. Private Sub Workbook_Open() Application.DisplayFormulaBar = False ActiveWindow.DisplayHeadings = False Application.DisplayFullScreen = True End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.DisplayFormulaBar = True Application.DisplayFullScreen = False ActiveWindow.DisplayHeadings = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Ribbon | Excel Discussion (Misc queries) | |||
Excel 2007 Ribbon | Excel Worksheet Functions | |||
How can I add the OneNote 2007 icon to the ribbon in Excel 2007? | Excel Discussion (Misc queries) | |||
[Office 2007] Auto-hide ribbon toggle button and control recent do | Excel Programming | |||
Hide ribbon or menu bar in Excel 2007 | Excel Programming |