Search results 189

Sorted from new to old.

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

jExcel

jQuery plugin to embed a spreadsheet, compatible with Excel, in your browser. ...

2019Oct3

CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

2019Aug1

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...

2019Jun2

DirTree.xlsb

Excel macro to show all files found in directory (including sub-directories) as ...

2019May20

Fancybox v3 apply

The newest version, made with mobile swipe in mind, and has a lot of features, ...

2019May4

Bootstrap lightbox

Simple easy bootstrap lightbox From

2019May4

Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

2019Apr25

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

Bootstrap 4 cheat sheet

Bootstrap 4 cheat sheet, quick direct link as image

2019Apr9

Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

2019Apr3

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

1 2 ...9 ...11 12