Its an old one but a gold one. The old DJS from Baarns. This is a bunch of useful bits and bobs to get you up and moving quickly with your VBA based systems.
As you look around various Excel utilities available from all corners of t’interweb you’ll often find descendants of this code.
Here is the link it says 97 but it works fine in 2003, and probably 2007 (apart from UI of course).
The idea is that you take their workbooks and code, make various simple setting changes and add your code and worksheets and you get a reliable .xla quickly. Much quicker than writing all your own code by hand for things like menus, scrollbars etc etc.
The link has more info but in summary the kit provides code for creating menus, including pop-ups, managing workbooks, dealing with the registry, and managing the workspace (great if you are a fan of dictator add-ins).
Even if you have no use for the features its worth looking at as an example of VBA coding.
And in terms of that compatibility, on the one hand its great that code from 10 years ago still works and still has value now. But on the other hand its possibly a little disappointing that things have moved so little that this is still a very relevant toolset.
Anyone else still got live code out there based on this?