Utilities and Code
|
By Curtis Frye
|
Chapter 1: Entering Data
Utilities
Macros
- Copying a Word Table Into Excel 97 Introduces Blank Rows
- Keep the Same Active Cell When You Move to a New Worksheet
Chapter 2: Format Annoyances
Utilities
- Office-Navigator
http://www.office-addins.com/-excel-addins/index.html#07
or
http://www.sharewareorder.com/Office-Navigator-download-download-19980.htm - Pac-Man
Macros
- Display the RGB Values of Colors in a Workbook’s Color Palette
- Search for Cells with Specific Formatting
Chapter 3: Formula Annoyances
Utilities
VBA Code
Chapter 4: Manipulating Data
Utilities
Chapter 5: Chart Annoyances
Utilities
- Blackjack
- CHARTrunner
- DeltaGraph
- Gradient Contour Chart Add-In
- Miner3D Excel Professional
- Office 97 Service Release 1 (SR-1)
- Office 2000 SR-1/SR-1a Update
- Power Utility Pak (PUP)
- Project KickStart
- Treeplan
- StatTools
- Xatellitesheet
- XLSTAT-3D Plot
- XLSTAT-Pro
Chapter 6: Exchanging Data
Utilities
- BusinessData2.mdb (967KB ZIP file)
- Dellinks.exe
- DigDB
- SQL*XL 3 and SQL*XL ADO
- Triple Yahtzee
VBA Code
Chapter 7: Printing
Utilities
Chapter 8: Customization, Macro, and VBA Annoyances
Utilities
- Accent Excel Password Recovery
- Advanced Excel 2000 Password Recovery
- CertMgr.exe
- Cryptainer LE
- Cryptomathic File2File
- Excel Locksmith
- Excel Password Recovery
- Excel Password Remover
- Excel & Excel/VBA examples
- FaceID.xls
- GuaExcel
- Lost Password: Excel Key
- Unbreakable
VBA Code
- Force a Macro to Affect the Active Workbook
- Use an If…Then Criterion Statement
- Run Time Runaround
- Range.Calculate Error
- Create a Workbook with a Worksheet for Each Month
- Pick Random Entries from a List
- Generate Non-Repeating Random Values
