How do I hide the 2nd menu down in form view (File Home Tell me what you want to do) in VBA? I've searched and nothing seems to work.
Thanks!
How do I hide the 2nd menu down in form view (File Home Tell me what you want to do) in VBA? I've searched and nothing seems to work.
Thanks!
As far as I can tell, you cannot, unless you roll your own ribbon. The modification might be
<tab idQ="HelpTab" visible="false"/>
or I guess just don't include that tab. I'm not sure if that search bar is a member of the backstage or what it belongs to.
Last edited by Micron; 11-25-2020 at 03:46 PM. Reason: added info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
As Micron indicated, create your own custom ribbon.
Use this code in a USysRibbons table to just show the full File & Home ribbons:
The result is:Code:<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"> <ribbon startFromScratch="true"> <tabs> <tab idMso="TabHomeAccess" visible="true" /> </tabs> </ribbon> </customUI>
You can also remove the Home tab completely and some/all items from the File tab. Or you can remove the ribbon completely
For more info, see http://www.mendipdatasystems.co.uk/i...y-2/4594571073
Thank you for your comments! Sometimes I open my database in form view and the ribbon is there and sometimes it not?
Mad-Tom
Do you mean sometimes the ribbon is maximised and at other times it is minimised?
Or do you mean sometimes it is hidden completely? That is only possible using VBA code
If so, the ribbon will be hidden ALWAYS unless you use code to show it again!