Search results 144

Header font name and size in VBA
Looks like it is not easy to change font name, size and style for a header or ...

Custom Excel UI ribbon
Excel custom ribbon in details. A good article I use as reference to add custom ...

VBA/Excel Registry hacks
Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

ANmaRemoveDuplicates2
Remove duplicated rows based on 2 columns in a table of any number of columns. ...

ANmaRemoveDuplicates4
Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

ANmAddress_Dimensions
Detects how many dimensions an address has, This is what I call it dimensions ...

Unblock blocked macros.
Unblock macros in file copied or downloaded from another machine. Excel keeps ...

CopyFiles Excel-Macro
Simple macro to make sure we have a copy of all files in a folder found in ...

Send workbook as email attachment
Retro way to send a workbook you are in as an email. Found it in one of my old ...

Macro keyboard shortcuts
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...