Works on Microsoft-OS’s and requires WIN32OLE !!
As an educational example, rather than a full-blown application, this tiny program works on a selection of spreadsheet-cells and calls some “processor-objects” in the order of their initialization in the program. The currently available two processors do 1. apply a background-color to the range of table-cells, 2. clear all contents from the range.
By creating other processor-objects, which register themselves automatically with the module, they are including, you can compose a processing-pipeline of specialized “processors” for reoccurring formating-, calculation-, cleanup-, … whatever-tasks.
ATTN! I do not use any Microsoft-Office, but another product, which can be controlled by what looks like a subset of the usual OLE-Objects, you might remember from VBA. It may be necessary (or not) to adjust the code to conform to the needs of your own spreadsheet-program. But then again, the current script does not do a lot and you will likely have to code your own processor-objects anyway.
Speak now or forever hold your peace:
of the dialog in action. Works.
Here is a screen-shot of the dialog in action.