Access 2010 - How to hide ribbon

Posted on 2013-06-05
Last Modified: 2013-06-05
New to Access 2010

I am trying to hide all of the ribbon in a MS Access 2010 application. I have modified the XML code for the ribbon and am able to hide all the buttons and tabs of the File menu, however, I am not able to hide the File menu tab at the top. I have searched the internet and find a recommendation for the following command:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

Where does the above code go? Will it hide the File tab, which as I have currently configured the ribbon, has no functionality?
Question by:jbotts
  • 6
  • 3
LVL 75
ID: 39222918
I pretty sure, but not 100.1% sure - that you cannot remove the File table - if you are in the ACCDB format (you can if in MDB format). However, I keep thinking ... "There MUST be a way"


Author Comment

ID: 39222995
I tried using:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

in the Open event of the first form that displays, but this did not have any effect. I have also used the following in the XML Ribbon table and it did not work:

<customUI xmlns="">
      <ribbon startFromScratch="false">

    <button idMso="FileCloseDatabase"visible="false"/>
    <tab idMso ="TabInfo"visible="false"/>  
    <tab idMso ="TabRecent"visible="false"/>
    <tabidMso ="TabNew"visible="false"/>
    <tabidMso ="TabPrint"visible="false"/>
    <tabidMso ="TabShare"visible="false"/>
    <tabidMso ="TabHelp"visible="false"/>
    <button idMso="FileExit"visible="false"/>

Best option so far is:

<customUI xmlns="">
      <ribbon startFromScratch="true">
      <button idMso = "ApplicationOptionsDialog" visible="false"/>
      <button idMso = "FileExit" visible="false"/>
      <tab idMso = "TabPrint" visible="false"/>

The above code will make all buttons and tabs in the File Menu (Backstage) not visible, but the File tab remains as does the Quick Access Toolbar.
LVL 75
ID: 39223046
Yes ...

How to render the Ribbon File Tab useless:

See my posts toward the bottom of the tread ... with XML for USysRibbons table, etc.

Author Comment

ID: 39223215
After review of the post, I guess the File Tab remains, but is useless, and cannot be hidden?
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

LVL 75

Accepted Solution

DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 39223249
Again, my gut feeling is ... There  must be a way. But so far, seems like no one has figured th is out ... that I can see.
LVL 75
ID: 39223278

Author Closing Comment

ID: 39223281
Thanks so much.
LVL 75
ID: 39223301
Seems every post I find shows how to disable items on .. the File tab, but not get rid of it.

Also ... get info on the de-facto standard ribbon tool site:

and here also:
LVL 75
ID: 39223325
You might actually want to leave this Q open for a while, although this Q comes up frequently.

I'm working with Ribbons a LOT more now, and I will be searching for a way to do this :-)

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Outlook Free & Paid Tools
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now