"Peter T" <peter_t@discussions wrote...
There's nothing wrong with the code. Not sure why the default Private has
been removed from the sheet events but that's not an issue.

I notice though you have a validation list. Unlike in later versions, in
Excel 97 changes applied from a DV list do not trigger a Change event.
....

But entries from DV lists do trigger Calculate events.