Similar codes

code image
Unblock blocked macros.

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

Jul27

code image
XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

2018Aug16

code image
O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

code image
List and delete files

Enables users to list and delete files

2018Apr23

code image
Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

code image
ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

code image
OpenOffice Macros

A pdf book, for macros in OpenOffice.org

2019Feb3

code image
UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

Nov28

code image
RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

Recently by developer

code image
ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

Thu 11AM

code image
JSon functions to add, read and delete entry

3 Json functions to read full node by an image, add full node to file or delete ...

Tue 12PM

code image
GetPapa + GetSon with variances

Gets the parent folder full name from a path Also Gets the son of a full path. ...

Sat 11AM

code image
HTMLTable_NoOfColumns

Gets no of columns in an HTML table. It actually gets the maximum number of ...

Sat 11AM

Random Codes

code image
ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

code image
VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

Jan24

code image
Too large procedures

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

2022Jan29

code image
ANC Bootstrap controls (Testing < and & # 6 0 ;)

Testing step in site (or in each HTML output function to replace < with < ...

2021Jun9