Building a System of Microsoft Windows Scripts to Control Excel Macros - Exchanging Data Between SAS and Microsoft Excel - page 227

The last step here in Excel will be to record another macro called “ make_thick_red_outside_border ”. The
module name is changed to “Common”. While this VBA code module has only one VBA subroutine, it
could contain many subroutines, since all VBA modules can contain many subroutines. This code is to
show you how to establish a pattern of how to build these modules and subroutines for generic use. If you
can do it for one module, you can do it for many.
Figure 13.3.12: Define Macro to Make a Thick Red Border Around the Data.
This macro shown in Figure 13.3.13 does the following:
● Selects the data cells (A1:E20).
● Sets the inside diagonal borders to no line.
● Sets the outside top, bottom, left, and right edges to a medium thickness red line.
● Sets the inside vertical and horizontal lines to a thin white line.
• Selects cell A1 when done.