Name Lister Add-In

Category: Add-Ins | [Item URL]

  • Description: The Name Lister add-in displays a list of all names in a workbook, by category (Workbook level, Sheet level, Hidden, Linked, and Invalid). The add-in also lets you delete names and activate named ranges interactively without closing the Name Lister dialog box. A more sophisticated version is available in Power Utility Pak.
  • Has Macros? Yes
  • Download: namelist.xla

Gantt Chart Demo

Category: General Files | [Item URL]

  • Description: Demonstrates how to create a "time line" (Gantt) chart in Excel. This type of chart is often use to depict various tasks in a project.
  • Has Macros? No
  • Download: gantt.xls

Conditional Row Delete Add-In

Category: Add-Ins | [Item URL]

  • Description: This add-in makes it very easy to delete rows based on the values in a specified column. For example, you can delete all rows that contain a value between 0 and 12 in Column F.
  • Has Macros? Yes
  • Download: rowdel.xla

Select By Format Add-In

Category: Add-Ins | [Item URL]

  • Description: The J-Walk Select by Format Add-In makes it very easy to select cells based on their formatting attributes. It's a much less sophisticated version of the utility in my Power Utility Pak.
  • Has Macros? Yes
  • Download: selbyfmt.xla

Date Report Add-In

Category: Add-Ins | [Item URL]

  • Description: The J-Walk Date Report add-in can help you identify such problems. The add-in generates a worksheet database report that describes each date cell in a worksheet. This was really popular in late 1999 when people were worried about the "Y2K problem.
  • Has Macros? Yes
  • Download: datereport.xla

Extended Date Functions (XDATE)

Category: Add-Ins | [Item URL]

  • Description: Excel cannot work with dates prior to the year 1900. The Extended Date Functions add-in (XDATE) corrects this deficiency, and allows you to work with dates in the years 0100 through 9999.
  • Has Macros? Yes
  • More Information: Click here
  • Download: xdate.zip

Cell Math Add-In

Category: Add-Ins | [Item URL]

  • Description: The Cell Math add-in provides an easy way to modify cells without using formulas. Some of the functionality of Cell Math is available through Excel's Paste Special command (using the Add, Subtract, Multiply, or Divide option), but Cell Math is much more versatile and easier to use.
  • Has Macros? Yes
  • Download: cellmath.xla

AcitveX Control Demo

Category: Developer Files | [Item URL]


Employee Time Sheet

Category: General Files | [Item URL]

  • Description: This workbook makes it easy for an employee to track his or her daily work hours. The employee simply enter the times, and the formulas calculate the hours. It even tracks overtime hours on a weekly basis (set up as 40 hours, but easily modified).
  • Has Macros? Yes
  • Download: time sheet.xls

Analog Clock Chart

Category: General Files / Developer Files | [Item URL]

  • Description: This workbook contains an XY chart that displays a working analog clock. It uses VBA to update the clock every second. This is really not a practical application. Rather, it's an interesting charting demonstration that uses VBA. The VBA project is not protected, so you can view the code.
  • Has Macros? Yes
  • Download: clockchart.xls

Page 4 of 5 pages
[Previous page]   [Next page]

Search Downloads


All Downloads

Browse Downloads by Category

Also of Interest

How to download

Most of the download links point directly to Excel files, but a few are compressed ZIP files. For best results:

  1. Right-click the download link
  2. From the shortcut menu, choose Save Link As or Save Target As
  3. Specify the location for the downloaded file.
© Copyright 2017, J-Walk & Associates, Inc.
Privacy Policy