By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,996 Members | 892 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,996 IT Pros & Developers. It's quick & easy.

Minimize ribbon with VBA in Excel 2007

P: 8
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.CommandBars.Item("Ribbon").Height = 150 Then

Application.ActiveWindow.ToggleRibbon()

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,
Sep 12 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.