MacroToolkit
MacroToolkit is userform of macros that is frequently used while working.
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.
download from here https://mcjoi80.gumroad.com/l/excelmacrotoolkit
* it is free but has time limitation.
Installation
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
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
| icon | function |
|---|---|
|
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 clear all filters. |
F#01 : Occasionally used features
| icon | function |
|---|---|
|
growthRate Calculate the growth rate. |
 |
achievementRate Calculate the achievement rate. |
 |
CAGR Calculate the CAGR. |
 |
WordFill If there is a value in the right side 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. |
 |
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.30(24.12)
some code optimization
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
