Beyond the Help files . . .

  Lunarpages.com Web Hosting

 

Access  ¨  Excel  ¨ FrontPage ¨ Outlook ¨ PowerPoint ¨  Word ¨    Miscellaneous  ¨  Tutorials  ¨  Windows

Free Downloads    ¨   Suggest an Article    ¨    Fix an Article
 


 


 

Free Downloads for Microsoft Office

Viewed times since 11 June 2005

Please report any broken links immediately so we may keep this resource up to date!

If you would like your download listed here, or even uploaded here for download, forward it to downloads@officearticles.com and we'll be happy to upload it and list it for you. Please include how you'd like to be recognized for your contribution.

You can get Microsoft's templates at Microsoft's Office site. Once there, just click on templates and do a search.

Check our own downloads folder; we are constantly adding new things, some of which relate to articles found here on our site. You can see our downloads at www.officearticles.com/downloads. Our free downloadable files and templates include:

#

App

Name of Download

Description

Website/Link

1

Excel

Climate Data Workbook

An interactive charting workbook that lets you compare the climate of two U.S. cities. It uses no macros.

J-Walk.com

2

Excel

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.

J-Walk.com

3

Excel

J-Walk Chart Tools

A collection of chart-related utilities.

J-Walk.com

4

Excel

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.

J-Walk.com

5

Excel

Animated Hypocycloid Charts

An Excel workbook that generates an infinite number of dazzling animated charts. You will be impressed.

J-Walk.com

6

Excel

Power Utility Pak v6

A collection of Excel utilities, functions, and enhanced shortcut menus.

J-Walk.com

7

Excel

Dice Roller

An Excel workbook that simulates rolling two dice.

J-Walk.com

8

Excel

Toolbar Calculator

An Excel add-in that creates a toolbar that functions as a simple calculator.

J-Walk.com

9

Excel

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.

J-Walk.com

10

Excel

Employee Time Sheet

Easy-to-use time sheet for tracking daily hours worked.

J-Walk.com

11

Excel

ActiveX Control Demo

Demonstrates the use of ActiveX controls on a worksheet

J-Walk.com

12

Excel

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 v6.

J-Walk.com

13

Excel

Children's Multiplication Exercises

Assists in learning multiplication tables. Contributed by Jim Hubbard. Instructive for children and adults who are learning VBA.

J-Walk.com

14

Excel

AddPath Add-in

An add-in that enables you to print a workbook's full path in a header or footer.

J-Walk.com

15

Excel

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. An enhanced version of this utility is available in PUP v6.

J-Walk.com

16

Excel

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 v6.

J-Walk.com

17

Excel

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 v6.

J-Walk.com

18

Excel

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.

J-Walk.com

19

Excel

J-Walk Conditional Row Delete

An add-in that makes it easy to delete rows based on the values in a specified column.

J-Walk.com

20

Excel

Timeline Chart

Demonstrates how to create an attractive "time line" (Gantt) chart in Excel.

J-Walk.com

21

Excel

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 v6.

J-Walk.com

22

Excel

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 v6.

J-Walk.com

23

Excel

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)

J-Walk.com

24

Excel

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.

J-Walk.com

25

Excel

Appointment Calendar Maker

A workbook that lets you generate and print daily appointment calendar pages.

J-Walk.com

26

Excel

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.

J-Walk.com

27

Excel

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.

J-Walk.com

28

Excel

Array Calendar

Demonstrates how to create a calendar for any month using a single (complex) array formula.

J-Walk.com

29

Excel

Another Gantt Chart

This one was featured in John Walkenbach's PC World column.

J-Walk.com

30

Excel

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. An enhanced version of this utility is available in PUP v6.

J-Walk.com

31

Excel

Custom Number Format Examples

This workbook contains several examples of useful custom number formats.

J-Walk.com

32

Excel

MP3 File Lister

A macro-driven application that creates an attractive listing of MP3 music files.

J-Walk.com

33

Excel

A Class Module to Manipulate a Chart Series

A useful class module that makes it easy to work with the data used by a chart.

J-Walk.com

34

Excel

Soundex Demo

Demonstrates a technique that lets you search for a text based on its sound.

J-Walk.com

35

Excel

GetOption Function

Demonstrates a useful function the displays a list of OptionButtons derived from an array. The UserFrom and VBA code are created on the fly.

J-Walk.com

36

Excel

Control the LED Display in the StatusBar

Originally developed by David Wiseman. It consists of VBA code that lets you control the "LED" display in Excel's status bar. I've always thought that this display was off limits, but David proved otherwise with some incredible programming. Very impressive! Thanks to David for letting me share this file with the world, and thanks to Jim Rech for modifying it so it works with Excel 2000.

This updated version is in the form of a class module (expertly programmed by Ole P. Erlandsen).

J-Walk.com

37

Excel

UserForm Hyperlink Demo

Demonstrates how to add hyperlinks to a UserForm Click

J-Walk.com

38

Excel

J-Walk FaceID Identifier Add-In

Makes it very easy to determine the FaceID value for a CommandBar image.

J-Walk.com

39

Excel

Charts in a UserForm

Demonstrates how to display one or more charts in an Excel 97 UserForm.

J-Walk.com

40

Excel

Menu Maker

A technique that makes it very easy to create a custom menu for an Excel 97 (or later) workbook or add-in. VBA programming not required!

J-Walk.com

41

Excel

Displaying Online Help

A technique that makes it easy to display help topics in a UserForm.

J-Walk.com

42

Excel

A Color Picker Dialog Box

Demonstrates a custom VBA function that displays a UserForm that lets the user select a color. Uses a class module.

J-Walk.com

43

Excel

Filling a ListBox With Unique Items

A clever technique to fill a ListBox with non-duplicated items in a list.

J-Walk.com

44

Excel

Handle Multiple UserForm Buttons With One Procedure

With an Excel 97/2000 UserForm, each control on the form has its own unique Click event, so you can't have several buttons that call the same Sub procedure. This workbook demonstrates a way around this limitation by using a class module.

J-Walk.com

45

Excel

ImageMap Demo

Demonstrates how to create a clickable image map for navigation within a workbook.

J-Walk.com

46

Excel