MacroToolkit : Readme

MacroToolkit

MacroToolkit is userform of macros that is frequently used while working.

 

Warning : Before using this

This Toolkit has not handled exceptions for all circumstances, which may result in errors.
So, I recommend that you should back-up excel file before using the Toolkit.

and The English translation is in progress, so it may not be accurate.

It can use only 7-days. after that, download and copy again.

 

Installation

Installation path

Copy to .xla file xlstart folder.

* default Excel xlstart folder path - C:\Users\[PC_USER_NAME]\AppData\Roaming\Microsoft\Excel\XLSTART

[PC_USER_NAME] : YOUR PC(USER) NAME

 

Launch

Before using this, must enable macros. (option > trust center)

In Add-ins ribbon Menu, click MacroToolKit button. or use keyboard shortCut {ALT + CTRL + SHIFT + Q}

 

 

Now, the userform of macros pops up.

* By version, icon arrangement and shape could be diffrent from image.

 

 

F#00 : Frequently used features

 

 

 

 

lineGray {ALT + SHIFT + 1}

Remove the guidelines and create the gray line.

* click : outskirt of the cell range selected, * double click : entire cell of the cell range selected

 

 

lineBlack {ALT + SHIFT + 2}

Remove the guidelines and create the black line.

* click : outskirt of the cell range selected, * double click : entire cell of the cell range selected

 

 

lineBlackBold {ALT + SHIFT + 3}

Remove the guidelines and create the bold black line.

* click : outskirt of the cell range selected, * double click : entire cell of the cell range selected

 

 

colorFill {ALT + SHIFT + 4}

fill gray color on the cell selected.

 

 

 

setA4

Adjust the page size for A4 size.

* recommended for new worksheet

 

 

delHyperlink

Delete hyperlinks. The format is all erased together.

 

 

 

delBlank

Delete all the spaces of the selected cell.

 

 

 

toFirstSheet

Go to the first sheet.

 

 

 

savebysheetname

Save each sheet as a separate file.

 

 

 

copyWidthHeight

Copy the width & height of the selected cell and paste it to the cell that is selected.

 

 

 

colorpicker

Copy the color of the selected cell and paste it to the cell that is selected.

 

 

 

fontset

Set the font of active sheet to "Segoe UI" 10pt.

* if using Korean apply "Malgun Gothic"

 

 

coloredRowDel

Delete the row of the colored cell from the selected area.

 

 

 

checkDuplication

In the selected area, color the redundant value.

 

 

 

removeDuplicates

Remove the duplicate value from the value of the selected area and make and paste a new sheet.

 

 

 

formatNum_normal

Change to a normal number format.

[yes - with right padding(accounting)] #,##0_-;[Red]-#,##0_-;-_-

[no - without right padding] #,##0;[Red]-#,##0;-

 

formatNum_thousand

Change in a thousand unit number format.

[yes - with right padding(accounting)] #,##0,-;[Red]-#,##0,-;-_-

[no - without right padding] #,##0,;[Red]-#,##0,;-

 

formatNum_mil

Change in a million unit number format.

[yes - with right padding(accounting)] #,##0,,-;[Red]-#,##0,,-;-_-

[no - without right padding] #,##0,,;[Red]-#,##0,,;-

 

formatNum_date

Change to a date format containing the day.

[yes - with day of the week] yyyy-mm-dd(aaa)

[no - without day of the week] yyyy-mm-dd

 

clearFilter

Turn off all filters(show all data)

 

 

 

 

 

F#01 : Occasionally used features

 

 

 

 

growthRate

Calculate the growth rate.

 

 

 

achievementRate

Calculate the achievement rate.

 

 

 

CAGR

Calculate the CAGR.

 

 

 

WordFill

If there is a value in the right side heat of the selected reference column, fill the cell value in a DB format.

 

 

allDecimals

In the case of numbers with decimal points, all decimal points come out.

 

 

 

shownamelist

Call the currently defined name list box.

* double click : activate name area

 

 

upsidedown

Return the data of the selected column and return it to the right side heat.

 

 

 

inputRandomValue

Enter the sequential date or random integer.

 

 

 

sepText

In the text that is mixed with characters+numbers, only the number is returned to the right side.

 

 

 

tableToArray

Copy the clipboard to set the table as a name definition.

 

 

 

pivotRefresh

Automatically update the Pivot Table.

 

 

 

SheetVisibilityControl(1) - sheetVisibleOrNot

Display visibility property table for all sheets in the current workbook.

* recommended to work on a new sheet

 

 

SheetVisibilityControl(2) - controlVisibility

Apply value for the changed visibility property.

 

 

 

SheetVisibilityControl(3) - sheetNow

Simply check with the message box to see if there is a hidden sheet in the current sheet.

 

 

 

 

 

Version History

v0.29(24.04)

some code optimization

 

v0.28(23.09)

Add language(Eng.)

 

v0.27(23.07)

Add functions(removeDuplicates, PivotRefresh)

some code optimization

 

v0.26(23.06)

Add functions(colorRowDel), page tab, ribbon menu, shortcut for start

 

v0.25(23.04)

Add functions(sheetNow)

 

v0.24(23.03)

Add functions(tableToArray, checkDuplication, fontset, copyWidthHeight)

Rearrange icons

 

v0.23(23.02)

Add functions

 

v0.22(22.12)

Add functions

 

v0.20(22.10)

Add functions

 

v0.21(22.10)

Redesign button

 

v0.10(21.07)

first init