| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vista/Excel 2007 VBA Determine if the Ribbon is minimized?
How can I programmatically determine if the Ribbon is minimized or not? I
need something like the imaginary function RibbonMinimized() as Boolean. -- TomThumb |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vista/Excel 2007 VBA Determine if the Ribbon is minimized?
How can I programmatically determine if the Ribbon is minimized or not? I
need something like the imaginary function RibbonMinimized() as Boolean. You can get the height of the Ribbon this way... RibbonHeight = CommandBars("Ribbon").Height and on my system, it is 150 when opened and 59 when minimized; however, I am sure those numbers are not fixed and vary with display resolution and other user settings. With that said, it would seem likely that 100 would be possible test point. I'm thinking of something like this... If CommandBars("Ribbon").Height < 100 Then ' Ribbon is probably minimized Else ' Ribbon is probably maximized End If Remember... that break point is a **guess** on my part. If I can find something more substantial, I'll post back. Rick |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vista/Excel 2007 VBA Determine if the Ribbon is minimized?
Thank you, Rick! You really nailed this one.
On my machine I get 55 minimized and 146 maximized. This is a real help to me, Thanks again -- TomThumb "Rick Rothstein (MVP - VB)" wrote: How can I programmatically determine if the Ribbon is minimized or not? I need something like the imaginary function RibbonMinimized() as Boolean. You can get the height of the Ribbon this way... RibbonHeight = CommandBars("Ribbon").Height and on my system, it is 150 when opened and 59 when minimized; however, I am sure those numbers are not fixed and vary with display resolution and other user settings. With that said, it would seem likely that 100 would be possible test point. I'm thinking of something like this... If CommandBars("Ribbon").Height < 100 Then ' Ribbon is probably minimized Else ' Ribbon is probably maximized End If Remember... that break point is a **guess** on my part. If I can find something more substantial, I'll post back. Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007-macro enabled, multi-sheet opening in minimized mode | Excel Discussion (Misc queries) | |||
| Excel 2007 and Office 2007 stink (so does Vista) | Excel Discussion (Misc queries) | |||
| Excel 2007 opens all sheets minimized | Setting up and Configuration of Excel | |||
| How can I add the OneNote 2007 icon to the ribbon in Excel 2007? | Excel Discussion (Misc queries) | |||
| Excel 2007 Hangs until Minimized | Excel Discussion (Misc queries) | |||
Linear Mode
