Styles_DeleteNonStandard

Delete styles from an Excel workbook, any non-standard style will be deleted. ...

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

RGB2HTML + HTML2RGB

Converts RGB color to / from HTML format As bonus, functions RGB_ExtractColor ...

FaceIDs

Excel menu icons and icon ids (named FaceIDs) used when yu create toolbars and ...

FaceIDs.zip

XLThumbView

Showing thumbnails inside sheet and enlarging each when click

XLThumbview.zip

InvertColor

Converts color into its negative value, as in "e4f15a" into "1C0FA6"

FGColor_Calc

To set the color of the foreground based on background color to get best look. ...

DeleteAllShapes

Delete all shapes in a sheet

RGB2Long

Converts Red, Green and Blue integers into RGB long value

ANStrColor2RGB + RGB2ANStrColor

Converts R:G:B into RGB value (as long) and RGB from long into R:G:B

FA5Icon_FromExt

Gets FontAwesome 5 icon for a file using its extension Used in MyDev website

Paging with Alternating Colors

This script will take the results of a query and sets up number of records per ...