| File |
Excel
Version |
Size |
Link |
Climate Data Workbook
An interactive charting workbook that lets you compare the
climate of two U.S. cities. It uses no macros. |
97 and
later |
320K |
More Info |
Gradient Contour Chart Add-In
An add-in that generates an alternative to Excel's contour chart.
Charts produced by this add-in are not dynamic. |
97 and later |
335K |
More Info |
J-Walk Chart Tools
A collection of chart-related utilities. |
97 and later |
347K |
More Info |
J-Walk Enhanced Data Form Add-In
Version 2.0. An alternative to Excel's Data * Form command. Lots of enhancements, and the VBA source code is
available (for a small fee) so you can customize it. |
97 and later |
353K |
More Info |
Animated Hypocycloid Charts 
An Excel workbook that
generates an infinite number of dazzling animated charts. You will be impressed. |
97 and later |
333K |
More Info |
Power Utility Pak v6
A collection of Excel utilities, functions, and enhanced shortcut menus. |
2000 and later |
2354K |
More
Info |
Dice Roller
An Excel workbook that simulates rolling two dice. |
97 and later |
289K |
More Info |
Toolbar Calculator
An Excel add-in that creates a toolbar that
functions as a simple calculator. |
97 and later |
144K |
More Info |
Clock Chart 
An Excel workbook that
contains an XY chart that displays a working analog clock. It uses a
VBA macro to update the chart every second. |
97 and later |
107K |
More Info |
Employee Time Sheet
Easy-to-use time sheet for tracking daily hours
worked. |
5 and later |
41K |
More Info |
ActiveX Control Demo
Demonstrates the use of ActiveX controls on a worksheet
|
97 and later |
110K |
More Info |
J-Walk Cell Math Add-In

An add-in that enables you to perform any mathematical operation on cells without using formulas. An
enhanced version of this utility is available in
PUP v5. |
97 and later |
181K |
More Info |
Children's Multiplication Exercises
Assists in learning multiplication tables. Contributed by Jim
Hubbard. Instructive for children and adults who are learning VBA.
|
97 and later |
121K |
Download |
AddPath Add-in
An add-in that enables you to print a workbook's full path in a header or footer. |
97 and later |
70K |
More Info |
Extended Date Functions
An add-in that provides a set of worksheet functions that enable you to work with dates prior to the year 1900
-- something that's not normally possible. These functions are also
available in PUP v5. |
97 and later |
76K |
More Info |
J-Walk Date Report Add-In
An add-in that generates a useful report that describes all date cells in a worksheet. This may help you
identify potential Year-2000 problems. An enhanced version of this
utility is available in PUP v5. |
97 and later |
74K |
More Info |
J-Walk Select by Format Add-In
An add-in that enables you to select cells based on formatting. For example, you can easily select all cells that
contain a specific number format and are red. An enhanced version
of this utility is available in
PUP v5. |
97 and later |
70K |
More Info |
Keno for Excel 97
A worksheet that simulates a Keno game. Just like the casinos - except you won't lose any money with this version. |
97 and later |
74K |
More Info |
J-Walk Conditional Row Delete
An add-in that makes it easy to delete rows based on the values in a specified column. |
97 and later |
73K |
More Info |
Timeline Chart
Demonstrates how to create an attractive "time line" (Gantt) chart in Excel. |
5 and later |
42K |
Download |
Name Lister Add-In
An add-in that displays a list of names in a workbook by category (all names, workbook level names, sheet
level names, hidden names, linked names, and "bad" names). An
enhanced version of this utility is available in
PUP v5. |
97 and later |
68K |
More Info
|
Superscript / Subscript Formatting Add-In
An add-in that enables you to add superscript or
subscript formatting to characters within a cell. An enhanced
version of this utility is available in
PUP v5. |
97 and later |
74K |
More Info |
Tony Gwynn's Hit Database
An Excel database with information about Tony Gwynn's first 3,000 hits.
Use the pivot table to summarize the data in various ways. (Tony Gwynn
is a baseball player on the San Diego Padres.) |
5 and later |
315K |
Download |
Menu Shenanigans
Makes a great April Fool's prank for an office-mate (preferably one with a sense
of humor). VBA macros reverse the text in all of Excel's worksheet menus.
The hot keys remain
intact, so the menus can still be accessed using familiar keystrokes. |
97 and later |
56K |
Download |
Appointment Calendar Maker
A workbook that lets you generate and print daily appointment calendar pages. |
5 and later |
47K |
More Info |
Guitar Scales and Modes
This workbook features a graphic depiction of a guitar fretboard, and displays the fret
locations for the notes in any scale or mode, in any key you choose. |
5 and later |
62K |
Download
|
Excel Doodle Pad
Etch-a-Sketch with a new twist.This workbook displays a doodle pad that lets you create
attractive symmetrical drawings using the arrow keys on your keyboard. |
5 and later |
46K |
Download |
Array Calendar
Demonstrates how to create a calendar for any month using a single (complex) array
formula. |
5 and later |
42K |
Download |
Another Gantt Chart
This one was featured in John Walkenbach's PC World
column. |
5 and later |
38K |
Download |
Hangman Game
The classic word-guessing game, programmed in VBA - complete with cheesy hand-drawn
graphics. Includes many words, and you can even add your own. A much
better version of this game is available in
PUP v5. |
5 and later |
68K |
Download |
Custom Number Format Examples
This workbook contains several examples of useful custom number formats. |
5 and later |
43K |
Download |