(see screenshot below) OR 3 Click/tap on the Customize Quick Access Toolbar menu arrow, and check the commands you want to add. I have tried looping the controls in the ribbon load method and setting the testing controls to enabled = false, locked = true, generatemember = false, but none of these hide the buttons from the QAT menu. 2 Right click or press and hold on a button (ex: Open Settings) in the Ribbon you want to add to QAT, and click/tap on Add to Quick Access Toolbar. This works, in the sense that the buttons do not appear on the ribbon, but if the user goes to Word's quick access toolbar > "More Commands" > "Choose Commands From" dropdown and selects my custom addin. In a brand new PERSONAL.XLSB, I created a simple macro (MsgBox 'Hello World'). ![]() Use this command to open the Open Existing File dialog. Command: Description: Browse computer: Adds the Browse Computer command icon to the Quick Access Toolbar. I tried to delete and re-create the PERSONAL.XLSB. The Customize Quick Access Toolbar menu is used to customize the quick access icons listed in the Working Papers header bar. If I add a Sub from a new workbook, or an add-in, it works just fine. I Have tried setting the testing buttons/groups to visible = false. Update: apparently, only the macros in my PERSONAL.XLSB do not work from the Quick Access Toolbar. I want the testing buttons to be completely invisible/inaccessible. ![]() When I send the product to the client I only show certain buttons. ![]() This is an ongoing project and some of the ribbon buttons are for users, and some are for testing/development purposes. The addin has a ribbon with multiple groups and multiple controls (buttons) within them. I have a custom addin for Word (could also be for Excel).
0 Comments
Leave a Reply. |