I added some code in an Excel file that told me whether I was done with the
active sheet or not. Basically, if I entered all the information I needed,
the tab colour would be green. Otherwise, it would be red. I used a
Workbook_SheetChange event and called a module that had the code. Upon
closing the file, I got prompted to save. I clicked Yes, it saved, and
reprompted me to save endlessly.

Basically, the code for the colour change was this:

ActiveSheet.Tab.Color = RGB (Insert colour code)

When I go to save, the Saved property is false. I have since taken the
colour code out, and it works fine. What am I missing? I would really like
this to work, as it is very handy as opposed to going to my Summary tab to
see what tabs need info.

TIA.
--
I am running on Office 2003, unless otherwise stated.