mightymacros Excel Utilities
Excel VBA Utilities Free Tool Kit
Latest Version 4.5.9
A row color sort has been added to the tool set collection under the row tools menu. The tool will sort row colors on a sheet having up to 7 colors. The sort configuration can be stored and used across multiple worksheets. A typical use might be applicable when sorting row data highlighted with styles of Good, Bad and Neutral. In cases where the top row is row 2 or row 3, the row number should be selected in the forms drop box before selecting the input column range. The latest modification brings the tool inline with Excels default color sort, providing the ability to color sort on a filtered list.
Row Color Sort Video
mightymacros Excel Utilities
Help file is included in the download
mightymacros AddIn Installer
mightymacros AddIn Installer makes installation easy when installing VBA Add-ins
mightymacros Excel Utilities Help File
Unblocking The Download
Installation Instructions for Installing an Excel VBA Add-in
1. Open Excel Options From Excel's Home Page
Form the File tab select options from the lower left hand home screen in Excel
2. Select Trust Center Under Excel Options
3. Select Trust Center Settings
Select Trust Center Settings
4. Select Macro Settings And Check 'Allow access to VBA project object model'
Select any Macro Setting other than 'Disable all macros without notification'.
5.Select Add-ins Under Excel Options
6. Open The Add-ins Dialog Box
Select the Browse button
7. Paste The xlam File Into The Browse Window
Make sure that Browse Path is C:\Users\[User]\AppData\Roaming\Microsoft\AddIns
Paste File and click OK button.
Note: If updating an earlier version uncheck the add-in in the add-ins dialog view then click OK to close the dialog, then follow the above steps to reopen the Add-ins dialog and go to the Browse window, paste and replace the old file, then select OK.
8. Add-in Installed
