In order to create you own nice looking tabs you need the Custom UI Editor for Microsoft Office. You can download it for free. How is this different from choosing File , Options , Customize Ribbon and adding a new tab with new groups and then commands to the group? You can also move the new tab to any position. T hen your new tab is always there. Even when you don't open the specific file with the right VBA. In my example the outcome looks like this, a nice tab, placed in front of the Home Tab. You will only get this tab when you start the specific example (which you can download). The XML behind this: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="false"> <tabs> <tab id="MaxIlze" label="Dossier Overzicht" insertBeforeMso="TabHome"> <group id="customGroup1" label="Adressen verrijken"> ...
Blog over software als Access, Excel, SQL, Crystal Reports, Report Builder, Word, VBA, elfstedentochten en andere regionale zaken.