E excelsean New Member Joined Sep 12, 2002 Messages 5 Sep 13, 2002 #1 From the Hall of Fame section of this site, I copied the color band macro and placed it into the worksheet code module. Next I selected File>Close and Return to Excel. Nothng happend. How do I "run" this type of macro? Thanks.