custom ribbon buttons by VBA

[muss1210]

Hello Forum

Is it possible with out the use of 3rd party software to create a custom tab and then a custom group in the ribbon that is available only in the workbook and for all users.

The company i work for will not let me install unknown 3rd party software so it is not a option.

Thank you in advance.

[Arkadi]

You need a few steps for that to work cleanly... opening the workbook should load the menu, closing it unload it. I tend to also add workbook activate/deactivate events to load/clear the menu, so that it does not interfere with other books.

In the ThisWorkbook module:

Please Login or Register  to view this content.

In a standard module:

Please Login or Register  to view this content.

[xlnitwit]

Hi,
You don't actually need third party software, it just makes the process a lot easier. You can create a CustomUI.xml file with the necessary XMl in it for your tab and controls, then add it to the zip file that makes up the workbook. If you can install an Excel add-in (xlam workbook), then Andy Pope has one on his website that will help immeasurably.