Custom Excel Right-Click Menus

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

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

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

Coming soon

Nice beautiful Coming soon page with progress bar

ComingSoon.zip

Anticipate WP

Under Construction plugin for wp

AnticipatePlugin.zip

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

MaxIF_MinIF_byNMR.zip

Posts per year-month

Create summary list If you have SQL table named Messages, with DateStamp ...

Posts Per Year

Create summary list If you have SQL table named Table_Name, with DateAdded ...

GenerateRandom

Generates a random string, returns string passed, then full date, then 8-chars ...

TreeView

A plain pure VBA Treeview control to be used inside Excel (official link has ...

treeviewexcel025.zip

XLShortcut_EnableDisable

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

Bootstrap Modal variables

Bootstrap link to pass variables to modal content Used to build list of links ...

MyMonthName

Returns the month name in one of 5 formats (below) It can use full date or ...