| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Minimize 2007 ribbon via VBA?
How to do it?!?
CE |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Minimize 2007 ribbon via VBA?
You can use this but it also hide the QAT
You must use ribbonx in the file if you want to see the QAT (post back if you want a example) Sub HideRibbon() Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" End Sub Sub ShowRibbon() Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)" End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Charlotte E" <@ wrote in message ... How to do it?!? CE |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Minimize 2007 ribbon via VBA?
Hi Ron,
Sorry for a late reply - got my head in this XL2007 all day :-) Got it working - thanks :-) CE Ron de Bruin wrote: You can use this but it also hide the QAT You must use ribbonx in the file if you want to see the QAT (post back if you want a example) Sub HideRibbon() Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" End Sub Sub ShowRibbon() Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)" End Sub "Charlotte E" <@ wrote in message ... How to do it?!? CE |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Minimize 2007 ribbon via VBA?
Hi! Different person here, but could you please give an example of using
ribbonx to show the QAT while hiding the ribbon. Thanks, "Ron de Bruin" wrote: You can use this but it also hide the QAT You must use ribbonx in the file if you want to see the QAT (post back if you want a example) Sub HideRibbon() Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" End Sub Sub ShowRibbon() Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)" End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Charlotte E" <@ wrote in message ... How to do it?!? CE |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| xls 2007 ribbon | Excel Discussion (Misc queries) | |||
| Minimize Ribbon | Excel Programming | |||
| Excel 2007 Minimize issue | Excel Discussion (Misc queries) | |||
| How can I add the OneNote 2007 icon to the ribbon in Excel 2007? | Excel Discussion (Misc queries) | |||
| how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit | Excel Worksheet Functions | |||
Linear Mode
