Jump to content
Strawberry Orange Banana Lime Leaf Slate Sky Blueberry Grape Watermelon Chocolate Marble
Strawberry Orange Banana Lime Leaf Slate Sky Blueberry Grape Watermelon Chocolate Marble

MSFN is made available via donations, subscriptions and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, register and become a site sponsor/subscriber and ads will be disabled automatically. 


Sign in to follow this  
ハイドン

Using VBA macros to hide the ribbon

Recommended Posts

I've been trying to completely hide the Ribbon interface in Office 2007, and I've made some progress through using VBA macros.

I know the Excel Ribbon can be hid with the following VBA code:

Sub HideRibbon() 
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub

And the following works with another program (I forget which):

Sub HideRibbon()
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Sub

But is there any equivalent to hide the Ribbon in Word?

Also, anyone know if its possible to show the Quick Launch Toolbar while hiding the ribbon?

Edited by ハイドン

Share this post


Link to post
Share on other sites

Or you could just choose minimize ribbon in the dropdown next to the quicklaunch.....

That will hide the ribbon, but it is still accessible. The macros I posted above completely remove the ribbon from Excel, and I think the other one is for Onenote. They remove everything; Office Button, Tabs, Ribbons, and the Quick Launch Toolbar (though that can be brought back through using RibbonX from what I've read). You can get an idea for what it does by reducing the height of a document window until the ribbon vanishes. In Excel the macro does the exact same thing but just makes it work with a larger window. I was hoping that there is an equivalent for Word, for I find it strange that the Office Team wouldn't have standardized this sort of thing.

Edited by ハイドン

Share this post


Link to post
Share on other sites
Or you could just choose minimize ribbon in the dropdown next to the quicklaunch.....

That will hide the ribbon, but it is still accessible. The macros I posted above completely remove the ribbon from Excel, and I think the other one is for Onenote. They remove everything; Office Button, Tabs, Ribbons, and the Quick Launch Toolbar (though that can be brought back through using RibbonX from what I've read). You can get an idea for what it does by reducing the height of a document window until the ribbon vanishes. In Excel the macro does the exact same thing but just makes it work with a larger window. I was hoping that there is an equivalent for Word, for I find it strange that the Office Team wouldn't have standardized this sort of thing.

Have you read the information presented in Customizing the 2007 Office Fluent Ribbon for Developers (Part 1 of 3), specifically the "Ribbon Customization Scenarios for Other Applications section"?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...