Acknowledgements
Some of the files on this page are also available at
Stephen Bullen’s website.
Excel versions
These files should all work in all recent versions of Excel, unless stated
otherwise. Some downloads have a dedicated version for Excel 2003 and one
for newer versions of Excel respectively.
Blocked files problem
Recently (I write this in August 2016), Microsoft has “enhanced”
security and is now blocking any files that are downloaded from the internet.
This means that any add-in you try to open after downloading will simply
not open in Excel (without display of a warning message!). To resolve this,
follow these steps:
1. Copy the add-in from the zip file to any folder
2. Right-click the xla(m) file and choose properties:
3. Click the Unblock button:
More about this problem in my article:
Excel: Add-ins do not
load
Donations
Excel add-ins and workbooks
Name of download
Description and download link
Ever had to work out the logic of other people’s Excel
files? Ever had to untie the spaghetti-knots of a large
Excel workbook’s formulas? Then you know what a nightmare
this can be!
Now there is the RefTreeAnalyser
!
Name Manager
The Name Manager An excellent utility to manage defined
names in your workbooks.
FlexFind
Flexfind eases searching and replacing throughout an
entire workbook. Also enables you to search and replace
strings in objects such as headers and footers, chart titles,
buttons and many, many more.
Autosafe
Autosafe.zip (Build 146, 4 Feb 2019, downloaded: 54.192 times)
New in Autosafe: Added setting to hide progress.
Version 3.5 of Autosafe enables use in environments with
long paths/filenames. The standard Autosave (note the spelling)
utility that ships with Excel just saves workbooks at a
set interval, overwriting the file on disk. This is not
very convenient if you planned to leave the master file
intact and save the changed workbook using a different filename.
It also does nothing to simplify recovery of unsaved/changed
documents after a system crash. This Autosafe utility creates
copies of open workbooks at regular intervals in a separate
(user-selectable) directory. It does not overwrite the master
file(s), that is up to the user to do, using normal methods.
As soon as a workbook is closed the backup copy is deleted
from the backup directory. If an abnormal termination of
Excel occurs, the backup copies remain on disk, and Autosafe
finds them the next time Excel is started and presents recovery
options to the user.
Autosafe comes with an autoupdate function which checks
for updates every week. Includes the following languages:
English, Dansk, Deutsch, Español, Français,
Indonesia, Italiano, Nederlands, Norsk, Hrvatski, Slovenščina,
Korean, Русский
(Russian), Lithuanian and Hungarian.
The previous version is still available:
Autosafe34.zip
(13 January 2003, 228k, downloaded: 11.081 times)
Note that this one shows a nag screen on networked computers.
Autosafe does not work on a Mac.
GoBack
GoBack.zip (8 April 2015, downloaded: 13.997 times)
Version 1.0 build 009.
Sometimes one has to edit a large workbook, with many
worksheets. This tiny utility keeps a record of the ranges
you have visited and gives you the opportunity to return
to previous selections using two hot keys: control-alt-p
to go to a previous selection and control-alt-n to go to
the next. It also creates a toolbar with a dropdown to select
a previous selection and to disable/enable the utility.
Now updated with ribbon user interface.
FollowCellPointer
FollowCellPointer.zip (7 Dec 2016, downloaded: 23.426 times)
Version 1.0 build 011.
A small tool which follows your cell pointer by placing
two arrows on top of your sheet pointing to the active cell.
Does not change your formatting and has an option to preserve
the undo stack.
Compare Two Tables
Compare2Tables.zip (April 2, 2019, downloaded: 765 times)
Version 1.0 build 005.
A tool which compares two tables. The tool produces three
new tables. Two tables containing the records which are
in table 1 and not in table 2 and vice versa and one which
lists all records which have been modified.
EUDA-template-EN.xlsm (19 Nov 2019, downloaded:
90
times)
EUDA-template-NL.xlsm (19 Nov 2019, downloaded:
18
times)
This template makes starting a new spreadsheet model easier as it already contains some functionality I think every model should have.
CloseAllWorkbooksAndQuit
CloseAllWorkbooksAndQuitExcel.zip (01 Oct 2015, downloaded:
3.364 times)
Version 1.0 build 001.
With the new MDI interface introduced with Excel 2013,
closing all workbooks has become unnecessary difficult.
This little addin adds a ‘Quit Excel’ button to your File
menu that will close all open workbooks and quit Excel.
It also features a Short-cut key: control+q
HeaderFooter
HeaderFooter.zip (24 August 2018, downloaded: 14.800 times)
Version 1.0 build 007.
Managing headers and footers in Excel can be a drag.
This little tool helps you to change headers and footers
in your files easily by means of a toolbar that shows dropdown/edit
boxes in which you can type the header/footer codes directly
or select them from the list of currently present header/footer
codes in your file.
SetupUtility
SetupUtility.zip (Updated May 5, 2008, downloaded: 16.964 times)
If you have created a nice add-in (see
this article
how to do that), a setup utility is an easy way for
your users to install your addin. This free utility just
needs you to change 4 cells to roll your own setup file.
Update: Now automatically removes invalid addins from
addin list.
UpdateAnAddin
UpdateAnAddin.xls (Updated February 19, 2007, downloaded:
20.423 times)
If you have created a nice add-in (see
this article
how to do that), an
updating mechanism
is an easy way to ensure your users get any bugfixes
you did automatically . This download demonstrates how you
can implement this functionality in your addin.
ShowTableOnUserform
ShowTableOnUserform.zip (14 May 2008, downloaded: 13.495 times)
For a project I needed a quick way to display the content
of an array to the user. I didn’t want to use a worksheet,
but opted for a userform. The data I wanted to show was
contained in an array. So I figured I’d put a listbox on
a userform and make sure the column widths of the listbox
resize with the data I want shown. That proved far from
easy… See this
article on how it works.
FixLinks2UDF
FixLinks2UDF.zip (02 June 2008, downloaded: 8.388 times)
A demo file that handles #Name! errors for workbooks
that use UDFs that reside in an add-in. See
this article on
how that works.
QueryManager
QueryManager.zip (Build 017, 23 September 2010, downloaded:
18.609 times)
This utility has been developed together with
Dick Kusleika .
It eases the editing of queries and Pivottable connections.
One can:
1. Edit the SQL string and the connect string of queries
and PivotCaches
2. Add parameters
3. Change the path to the data source
All in a single dialog.
AutosafeVBE
AutosafeVBE.zip (build 026, 6 Aug 2007, downloaded: 23.743 times)
This utility makes backup copies of VBA components to
a user-defined directory. It keeps a user selectable number
of copies of each component. It thus keeps a number of generations
of your code as your work progresses, enabling you to return
to a previous copy when things go wrong. Because it just
exports the VBA components, it is unobtrusive because this
process is relatively fast compared to saving your workbook
or document. Excel and Word version included!!
Non linear Least Squares
nonlinearls.zip (12 Apr 2012, downloaded: 21.703 times)
Fit complex functions like y=exp(a.x).sin(x) + b to data
using Least squares
ExcelVBEMultilineSR
ExcelVBEMultilineSR.zip (Version 1.0, Build 004, 27
Nov 2008, downloaded: 10.118 times)
This utility enables you to do Search and Replace operations
in the Visual Basic Editor of Excel. What is special about
this tool is that you can search for multiple lines of code
and replace with multiple lines of code.
WARNING: ALPHA VERSION, USE AT OWN RISK!
CopyVBAProject
CopyVBAProject.zip (Version 1.0, Build 011, 22 Jun 2016,
downloaded: 12.019 times)
This utility enables you to copy the components from
the VBAProject of workbook A to Workbook B
USE AT OWN RISK!
ExportVBAProject
ExportVBAProject.zip (Version 1.0, Build 005, 1 Sep
2015, downloaded: 7.522 times)
This utility enables you to copy the components from
a VBAProject to a single text file. Very useful if you need
to compare the VBA code of two Excel files. Use this handy
tool to compare differences in the exported files:
ExamDiff
PerformanceClass
PerformanceClass.zip (Version 1.0, Build 001, 20 Aug
2014, downloaded: 4.905 times)
This example file demonstrates the use of a class module
to measure performance of your VBA code. See
A VBA performance
class for an explanation.
TrustedDocumentManager
TrustedDocumentManager.zip (Version 1.0, Build 001,
10 oct 2013, downloaded: 5.036 times)
This little tool enables you to manage your list of trusted
documents. Currently, Excel only allows you to either leave
the list intact, or delete the entire list. This means all
of your currently trusted documents become untrusted again
so you have to enable macro’s on all of them once again.
The tool allows you to remove just one file, remove an entire
folder or even an entire drive. Also it offers the possibility
to remove files which no longer exist from the list.
Only available for Excel 2010 and up!
ObjectLister
Objectlister.zip (Version 1.0, Build 003, 1 October
2008, downloaded: 15.771 times)
Lists objects, properties and methods of the selected object
and enables you to quickly build code that uses many properties
of an object. See the
ObjectLister page
for more information.
VBA driven circular references
AutoChrt
AutoChrt.zip (2 March 2015, downloaded: 23.717 times)
Automates the process of creating graphs from database-like
datasets, where you need to chart various columns against
each other in x-y scatter charts to determine relationships
between them. It consists of a sheet where to copy the data
into and a sheet that holds the chart and some spinner-buttons
to control which data are charted.
Simple Inventory System
SimpleInventorySystem.zip (11 Oct 2016, downloaded: 9.260 times)
A simple inventory system built in Excel using simple
formulas.
Moving Checkbox
MovingCheckbox.xlsm (29 Feb 2016, downloaded: 10.253 times)
A small demo file which contains a column in which a
checkbox is automatically displayed tied to the underlying
cell.
ChartAnEquation
ChartAnEquation.zip (May 1, 2005, downloaded: 14.674 times)
Demonstrates a method to chart a mathematical equation
using just defined names.
See this article
for an explanation.
ControlHandler
ControlHandler.zip (17 June 2005, downloaded: 11.873 times)
Demonstrates a method to handle the events for multiple
controls on a worksheet using a single class module. See
this article
for an explanation.
ControlLister
ControlLister.zip (10-7-2014, downloaded: 7.087 times)
Tool that lists all controls on your userforms on a worksheet.
Includes code to rebuild the userforms from the table. Note:
does not handle userforms with multipage controls very well!
CatchPasteDemo
CatchPasteDemo.zip (17 Dec 2007, downloaded: 11.583 times)
Demonstrates how to intercept paste operations in a workbook
to prevent users from wrecking your validation. The download
contains two workbooks; one for Excel 2003 and earlier,
the other for Excel 2007 and 2010. See
this article for an
explanation.
UndoHandler
UndoHandler.zip (8 March 2006, downloaded: 14.767 times)
Demonstrates a method to enable the user to undo changes
made by your VBA code. See
this article for
an explanation.
WatchOtherCell
WatchOtherCell.zip (18 September 2012, downloaded: 12.291 times)
This workbook simplifies looking at data in a sheet with
a lot of columns. It shows the value of a cell on the same
row in a column one can enter in a textbox. This way you
can scroll all over the sheet and always (e.g.) have the
value of a cell in column BE in view. Start the watcher
by opening the file and using its entry in the Tools menu.
GetARange
GetARange.zip (4 May 2006, downloaded: 15.974 times)
This workbook demonstrates a bug in the VBA Application.InputBox
function as described
here . The workbook
also contains a userform and sample code to work around
that bug.
EditOpenXML
EditOpenXML.zip (5 September 2011, downloaded: 13.949 times)
Wouldn’t it be useful to be able to edit the contents
of an Office 2007 OpenXML file from within VBA? Well, now
you can using this demo file.
Find a full
description here .
ModelessformOnTop.zip (26 November 2012, downloaded:
6.784 times)
Excel 2013 now has a SDI as opposed to the MDI previous
Excel versions have. This file demonstrates how to keep
a modeless userform on top of the Excel 2013 window.
Find a full description
here .
Arg2Name
Arg2Name.zip (8 February 2001, downloaded: 19.961 times)
This workbook demonstrates a trick to pass (range) arguments
to defined name formula’s. See the
Excel names page.
xlMenuFunDict
xlMenuFunDict.zip (29 Jan 2003, downloaded: 25.809 times)
International versions of Office have the menu system
in their local language. Also the Excel worksheet functions
are (mostly) listed in local language. This complicates
communication with the users with such a version. To aid
in this process a utility has been devised that creates
and shows a translation list of the Excel built-in command
bars and controls and the Excel worksheet functions. This
workbook can also list command bars of other Office software
packages. It thus enables the international user who is
using a different language version of Excel to quickly find
translations for sequences of menu commands and function
names.
No comments:
Post a Comment