Minimize Ribbon VBA

[WilliamJones]

Have searched these forums and others and still unable to find solution.

Would like to be able to toggle the Ribbon in 2007: minimized and back.
This is part of a custom ribbon application where the ribbon needs to be visible at all times but the user can minimize through a toggle button on the ribbon.

I dont want to hide the ribbon, only minimize it. Sendkeys might be the only way to go, but I need to capture the state.

as an analogy, i want something like this toggle:

Please Login or Register  to view this content.

but to minimize the ribbon.

[royUK]

So why not use FullScreen?

[WilliamJones]

So why not use FullScreen?

Good question. AFAIK, when you go to fullscreen there is nothing there to tell the user how to get the menu back - whereas if i leave the ribbon minimized they should be able to easily go back to a normal view. I'm not saying the average user is a moron, but many will look at the full screen with a blank look and not figure out what the escape key is for. As a design consideration, I want all menus and selections in the ribbon, consequently I want to avoid putting a control in the sheet itself to restore the view.

For example, I use checkboxes in the ribbon itself for certain selections (with a callback to preserve the true/false state if the file is saved, closed, and reopened) i.e. no controls in the sheet. Similarly, I would prefer not to put instructions in the sheet either...for example "Hit escape to return to normal view". I had thought of putting a message in the application caption, but not sure user would notice it.

merry xmas

[Andy Pope]

Send keys is needed.

Please Login or Register  to view this content.

[WilliamJones]

Send keys is needed.

Please Login or Register  to view this content.

Despite my aversion to sendkeys, that will be the way to go. Happy Holidays.