mightymacros Excel Utilities

PreviousPage 1 of 4

Excel VBA Utilities Free Tool Kit

Excel Utilities

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

mightymacros AddIn Installer

mightymacros AddIn Installer makes installation easy when installing VBA Add-ins


Download


Read More...

mightymacros Excel Utilities Help File

Unblocking The Download

Files downloaded from the internet may automatically be blocked for your safety
If this is the case then unzip the zip folder and right click the .xlam or .chm file then tick the Unblock box.

Unblock File

Installation Instructions for Installing an Excel VBA Add-in

1. Open Excel Options From Excel's Home Page

Options


Form the File tab select options from the lower left hand home screen in Excel


2. Select Trust Center Under Excel Options

Trust Center

Select Trust Center

3. Select Trust Center Settings

Trust Center Settings


Select Trust Center Settings

4. Select Macro Settings And Check 'Allow access to VBA project object model'

Macro Settings


Select any Macro Setting other than 'Disable all macros without notification'. 

5.Select Add-ins Under Excel Options

Manage Add-ins

Go to Manage and select Excel add-ins in the drop box and click the Go... button

6. Open The Add-ins Dialog Box

Add-in dialog


Select the Browse button

7. Paste The xlam File Into The Browse Window

Browse Paste


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

Addin Installed
Select the OK button and close the dialog