mightymacros Excel Utilities

PreviousPage 1 of 4

Excel VBA Utilities Free Tool Kit

mightymacros Excel Utilities

Version 4.6.9

A new workbook tool called Create Workbooks has been added to the toolset, it converts sheet tabs into separate workbooks. Also new functions have been added to Count Filter, including a total count, item percentages and blank cell stats. The option to filter Excel dates is now included within all the filter tools. Create Tabs has been updated and can now split data of varying date formats onto separate tabs.

Version: 4.6.6

Another new filter tool called 'Count Filter' has been added to the tool set. The tool provides a quick descending order count of recurring items within a range or table and loads the item count into a list box. A filter can then be applied by simply selecting any item within the displayed list. 'Create Tabs' and 'Click Filter' can now be used on Excel tables.

Version 4.6.4

A new filter tool has been added called 'Click Filter' The tool lets you filter by any item, simply double clicking the item on the sheet.

Create tabs has been updated. The revision provides the option to select the header row containing the column-titles. This preserves the row information that may be above the column titles when the data is split onto separate tabs. Additional changes include the provision to split information by date onto separate tabs. Tab names are based on the data being split. Tab name length and character requirements are now configured to be within Excel's requirements.


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