Ribbon Bar and Quick Access Toolbar




I am trying to disable everything in the Ribbon Bar and also remove the
downward arrow button for the quick access toolbar as there will be no
options for users here either.

I have tried the following XML

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
<button idMso="FileCompactAndRepairDatabase" visible="false"/>
<button idMso="FileOpenDatabase" visible="false"/>
<button idMso="FileNewDatabase" visible="false"/>
<splitButton idMso="FileSaveAsMenuAccess" visible="false"/>

previously I tried

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
<control idMso="FilePrintQuick"/>

which a user has posted on another site but it left Open and New in the menu
hence I used the other code which states they are not to be visible. However
even that still leaves out Close Project and I dont want anything appearing
except perhaps Exit Access but I cannot find any reference to this to state
visible=false, any ideas?

Secondly I want the arrow that opens the Customize Quick Access Toolbar menu
to be hidden, I tried

<button idMso="QuickAccessToolbarCustomization" visible="false"/>

but thats made no difference.

Perhaps it is not possible to completely remove all options so would be
grateful for any replies that can answer the above. Removing all options from
the Quick Access Toolbar except Undo and Redo would be helpful if possible.

Thanks very much


P.S. Can the help button to the far right of the ribbon bar be hidden?!!?,

Jeff Conrad


I don't have Access 2007 in front of me at the moment so I cannot test anything, but I believe the
Close button in the Office Menu is referred to as FileCloseDatabase.

I don't know of any way (yet) to disable or hide the Help button or the QAT arrow itself.

Would you like to try something quick and easy?

Here's a little "Inside Out" tip for you:

1. Make sure you have a startup form enabled in Access Options (hopefully like a switchboard type
2. Close your database and Access
3. Use Windows Explorer and find the database
4. Change the extension from .accdb to .accdr (Click Yes when Windows prompts you about changing the
5. Re-open your database

How do you like that?

Will that suffice?
Jeff Conrad - Access Junkie - MVP
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007 Info: http://www.AccessJunkie.com

in message:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question