Download Latest Version Toolbox.zip (111.2 kB)
Email in envelope

Get an email when there's a new version of Excel Toolbox

Home / Toolbox_0
Name Modified Size InfoDownloads / Week
Parent folder
Toolbox.zip 2021-09-01 111.2 kB
1 1 weekly downloads
readme.txt 2021-09-01 2.6 kB
0
Toolbox.xla 2021-09-01 138.2 kB
0
ToolboxRibbonEdit.xls 2021-08-31 58.9 kB
0
ToolboxRibbon.xlam 2021-08-31 12.4 kB
0
ToolboxQ7.xlam 2021-08-31 14.2 kB
1 1 weekly downloads
ToolboxQ3.xla 2021-08-31 36.9 kB
0
LICENSE.txt 2021-08-31 975 Bytes
0
Totals: 8 Items   375.4 kB 2 
Toolbox 
(C) Copyright 2008-2017,2021 Ernst Dijk


Files in this package :

Toolbox.xla           = toolbox addin with dropdown menu, commandbar(s) and help.   

ToolboxQ7.xlam        = Excel 2007 'quick access commandbar button' for the toolbox dropdown menu.
ToolboxQ3.xla         = Excel 2003 'quick access button' for the toolbox dropdown menu.

ToolboxRibbon.xlam    = Excel 2007 menu (ribbon)
ToolboxRibbonEdit.xls = Toolbox menu/ribbon editor (limited). 

license               = standard 'MIT No Attribution' license
readme.txt            = this file


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' 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, a 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 changes an 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 a QAT button.


version 0.07d
Source: readme.txt, updated 2021-09-01