You would have to save the workbook in order to save the code.

Also, why would you expect anybody reading your message to know what
"posts from 7/06" and "posts for 7/07" refer to?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Counting Cells With Fill Color"
wrote in message
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?