Only Access 2010 / 2013 - FAQ |
FAQ (Access 2007/2010/2013) |
In contradiction to the description available with the "Help Button", this Toggle Button can not be deactivated.
The following XML code will be executed without error message, the Toggle Button will remain active.
<commands> <command idMso="MinimizeRibbon" enabled="false"/> </commands>
#CMSimple hide#
For these Checkbox there's no RibbonXML Callback available, furthermore there's no option (SetOption) that could be set by using VBA.
Use following RibbonXML to hide the MRU:
<backstage> <tabidMso ="TabRecent" visible="false"/> </backstage>
or:
This setting is made to the registry and will be stored for the current user.
Use the following code to hide or display the recent databases at startup.
'Code into a new standard module: Public Enum ShowQuickAccesDisplay show = 1 hide = 0 End Enum Public Sub SetBackstageQuickAccessDisplay(iShow As ShowQuickAccesDisplay) Dim objWSHShell As Object Set objWSHShell = CreateObject("WScript.Shell") objWSHShell.RegWrite "HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\File MRU\Quick Access Display", iShow, "REG_DWORD" 'In Excel use : ' objWSHShell.RegWrite "HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\File MRU\Quick Access Display", iShow, "REG_DWORD" 'In Word use: ' objWSHShell.RegWrite "HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\File MRU\Quick Access Display", iShow, "REG_DWORD" Set objWSHShell = Nothing End Sub
Use:
SetBackstageQuickAccessDisplay show 'Display
respectively:
SetBackstageQuickAccessDisplay hide 'Hide
Ensure the resetting of the original value on closing the database.
#CMSimple hide#
Assume you have configured the help button to initiate a customize callback:
<commands> <command idMso="Help" onAction="OnActionHelpButton"/> </commands>
While a click on the help button on the ribbon initiates the callback in a proper way, a click on the help button in the BackStage area opens the
Access help.
This is a bug in Access 2010 and the only option is to disable the Help button completely.
<commands> <command idMso="Help" enabled="false"/> </commands>
#CMSimple hide#
No, you cannot hide only the "File" Tab.
The following Code hide the Ribbon (with File Tab and BackstageView Menu):
DoCmd.ShowToolbar "Ribbon", acToolbarNo
View Ribbon:
DoCmd.ShowToolbar "Ribbon", acToolbarYes
#CMSimple hide#