I read the posts from 7/06 about how to count cells that have a specific fill
color. We are using fill colors in an excel spreadsheet to indicate tasks
that are completed for a project we are working on and we used the code that
was supplied in the posts for 7/07. My problem is, when I close the Excel
spreadsheet and then open the spreadsheet back up, it does not recognize the
name ColorIndex from the VBA code. What we are doing is deleting all the
code and entering it again as if we were doing for the first time. Is there
a way to keep everything so we don't have to keep doing this every time we
open and close the Excel spreadsheet?