disappearing worksheet_change VBA code - help!
 

I created worksheet level code triggered by the worksheet_change event.
The code works fine, but I can't see it when I click on the sheet
object anymore.

Even stranger, if I create new code in the sheet like this:

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "boo!"
End Sub


Then I get the behavior from my missing worksheet_change code, *plus* I
get the "boo!" message. So the "missing" code is clearly still being
executed. (The code's not anything complicated--it just looks for a
change in a particular cell, then changes the color of some text in a
range.)

I've replicated this on two machines, one with Excel 2000 and one with
Excel 2003.

Things I've tried:

- running the code cleaner utility at
http://www.appspro.com/utilities/Cleaner.asp
- looking to see if accidentally put the code at the workbook level (I
didn't)

I'm totally at my wits' end. Any ideas?

disappearing worksheet_change VBA code - help!
 

Um ... never mind ... I forgot that I originally decided against using
the worksheet_change event, and instead used a conditional formatting
trick to accomplish what I wanted. So there never was any
worksheet_change code. Oops.