This may not be much use to you as I don't know whether this also
applies to XL97, however, John Walkenbach, in his 'Microsoft Excel
2000 Power Programming with VBA' and his 'Excel 2002 Power Programming
with VBA' explains how to do it with a class module. I did a google for
"multiple buttons, one event  handler"
with the the quote marks, and found a useful pdf not distantly related
to the above.