All Version Workbooks

Fast Filter

Roger Govier — Mon, 10 Mar 2008 12:32:25 GMT

With FastFilter, you can type criteria in the row above an AutoFilter, instead of selecting from the

dropdown lists. The cells with criteria change colour, so you can easily see which columns have a filter applied,

and see what the criteria are. You can filter one or more of the columns.
This ZIP file replaces the previous loaded xls file.

Write worksheet comments to text file

Nick Hodge — Thu, 24 Jan 2008 22:44:35 GMT

This file uses the VBA output routines to take comments in a workbook and write them out to a text file. It appends in the text file the sheet and address from whence they came. There is also a routine to copy comments in one sheet to the same cells in another.

Build a worksheet index with hyperlinks

Nick Hodge — Tue, 15 Jan 2008 21:23:00 GMT

This workbook has a sheet of each type available in Excel. if you click on the 'Create Index' button, it adds a worksheet with the worksheet name, type and, if possible, a hyperlink to that sheet. It just a file by way of VBA demo. (Alt+F11 to look at code)