I am trying to figure out how to minimize the ribbon when the program starts up. From what i've read, the only way Excel can recognize is by the height of the command bar. I have a rough sketch of code that has been discussed, but none have verified one working.
If Application.Com mandBars.Item(" Ribbon").Height = 150 Then
Application.Act iveWindow.Toggl eRibbon()
Else
'Whatever you need to do when minimized
End If
I am not sure about the actual pixel height. For at least one of the Office 2007 programs, the minimized bar is 59 and maximized is 150. Anyone know how I can make this work?
Thanks,
If Application.Com mandBars.Item(" Ribbon").Height = 150 Then
Application.Act iveWindow.Toggl eRibbon()
Else
'Whatever you need to do when minimized
End If
I am not sure about the actual pixel height. For at least one of the Office 2007 programs, the minimized bar is 59 and maximized is 150. Anyone know how I can make this work?
Thanks,