Home

Excel Toolbox

Introduction.
It starts with a few macros, one excel addin and a menu. More macros. More addins. More menus.
To many. Resulting in unreadable buttons names and/or switched off menus.
Put them all in one place, in one menu. In one Toolbox.
A toolbox with a readable dropdown menu and a customizeable commandbar and/or ribbon.

Help pages. Form windows are to small and block macro execution. Seperate documents get lost.
Help on an excel sheet inside the toolbox. User is shown a copy.
The help page is kept readable with a kind of group/outline. If a chapter opens others are closed.
.

Toolbox.

The menu/commandbar is created from the 'menu' worksheet/table inside the Addin.
The user can edit that table, test the new menu, but can only save it if the Addin is installed.

There is also a 'default menu' sheet/table, this sheet is hidden. There are 2 macro's to edit and save this table.
Same aplies to the 'help' sheet, a hidden sheet. If the user presses 'Help' a copy of the help sheet is shown.
.

Ribbons.

A ribbon is a XML file inside the xlam file (a zip file). To edit that XML file the xlam file must be closed, unzipped, etc. Long store short, an addin can not edit its own ribbon.
You can put the editor/builder inside your addin and have a seperate ribbon addin.
Or have a special tool to change the ribbon of your addin.
Or, as in this demo, all three. A macro addin, an ribbon addin, and a tool to modify the ribbon.

The menu/ribbon is created from a worksheet/table and placed inside the ribbon addin.
The "generate" button only works on the installed copy of the addin.
To change your master version, see VBA code for the macro.

Note: ToolboxRibbonEdit.xls uses not only VBA, but also VBS to zip/unzip.
Using VBS may blocked by company IT department.
.

Final.

Menu can be changed by the user - it turned out that nobody ever did that for real.
Ribbon even worse, nobody is using it.
Everybody uses the dropdown menu with readable names. Easy accessable with the QAT button.

version 0.07b