Search results 63

Sorted from new to old.

Hack VBE password in .xlsm

Remove VBE project password protection off of xlsm. This is screenshot on how ...

2025Dec30

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

2025Sep30

ANmaCountChars_Direction

Counts how many times we found OfChar repeated in TheStr from one of two ...

2025May24

ImageMSO list

List of all images in ImageMSO used in ribbon as well in other parts of VBA in ...

2025Apr30

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

2024Sep21

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

2024Mar4

NumberBeforeString_HTML

Cuts a number that would be found before certain word inside a block string. ...

2024Feb1

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

2023Dec25

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30

FontAwesome icons in Office apps

Best way to use FontAwesome set of icons in apps, mainly my Excel tools and ...

2023Jan31

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

1 2 3 4