Thanks, Gary.

I had actually just stumbled onto something that works, too. Here is what I
did:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$25" _
Then
***run my code to hide and unhide sheets***
End if
end sub

Cell B25 is the cell that I want to monitor for changes. Changes to any
other cell will not run my code.