Power Tools
This is where I keep all the cool stuff that makes Excel insanely great, and which you won't find anywhere else - well, mostly.
VBA tools
The first three are used in the project templates on this site, so the links will take you to the templates.
New - how to create tag clouds in Excel, with VBA
-
Worksheet Tools
- Link - Managing a user interface with sets of controls
- Link - Using the camera tool to take pictures of charts/tables and use them for presenting results
- Link - Automating Excel to run a series of scenarios or process rows of data, without any code
- Link - How to make automatic backups when you save - and avoid overwriting previous backups
- Link - Collections are very powerful but have limitations - this class enhances them
- Link - More statistically reliable random numbers (if you are using older Excel versions than 2003)
- Link - Sample code to log user activity (for debugging) - includes useful system information
- Link - Encrypt strings and files using the CryptoAPI built into Windows
- Link - Embed binary data in a workbook for greater compression and security
- Link - Sign worksheets with a digital hash and the user's name, to detect changes
- Link - Embed hidden messages (steganography) in worksheet tables
- Link - Using lossy compression to dramatically reduce the size of data
- Link - A system for storing (securely) encrypted data which users can access with a PIN number
- Link - Excel can be for fun - an electronic greeting card
- Link - Sudoku -a workbook to solve it, give hints, even create new puzzles of varying difficulty
- Link - solve those 9 letter word puzzles - this workbook has all 104,000 official words
VBA Tools
Exotic and unusual
Fun
Note: Where possible, I've attributed ideas to the people who thought of them. If I have missed someone or made a mistake, please let me know.