Hi R,

However, I am trying to wrap some of this code in a class, and I
am having trouble. The OnAction parameter can't refer to a class's
procedure (as far as i know), and there are no events that the
CommandBarPopup sources... so how can I accomplish this? Any help would
be most appreciated.

Only the CommandBarButton and CommandBarComboBox source events, so you need
to use those objects in your class modules (usually the CommandBarButton)

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk