"Harlan Grove" wrote in message
"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.

Only indirectly if linked to a formula in another cell, eg =A1 where A1 is
the DV cell. Indeed this is the normal suggested workaround for Excel 97,
but there are others too.

Regards,
Peter T