Search results 17

Sorted from new to old.

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

2022Jan29

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

Multi-level menu

CSS only. Bootstrap multi-level menu Originally from

2019Jun19

Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

2019Jun16

HttpToAnchors

Convert http found inside text into anchers < a >, aka URLlinker, aka ...

2019Mar30

Protect VBA

Protect VBA project from inside VBA This is the raw way, there has to be other ...

2019Jan1

a href=#

Instead of using href="#", it is better to use href="javascript:void(0);" to ...

2018Sep12

RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

2018Aug9

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

CreateZipFile_7Zip

Compress a single file into zip archive using 7Za.exe 7za.exe (found in ...

2018Jul14

SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5

CellHyperlink_ToSheet

Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...

2018Jun24

Email-CDONTS

CDONTS with Attachment Example of CDONTSwith attachment for emailing

2018May27

GoToInternet

Opens webpage from within Excel, using default browser

2018May22

InsertHyperlinks + GetHref

Converts https found in text into anchers < a > Comes with GetHref as bonus ...

2018May13

1 2